Re: data comparision in Oracle
This is a discussion on Re: data comparision in Oracle within the Oracle Miscellaneous forums, part of the Oracle Database category; --> I noticed that the date format is wrong. I've changed the query to select * from tableA where to_date(substr(errinfo$datetime, ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-07-2008, 09:24 AM
| ||||
| ||||
 Re: data comparision in Oracle I noticed that the date format is wrong. I've changed the query to select * from tableA where to_date(substr(errinfo$datetime, 1, 19),'yyyy-mm-dd hh24:mi:ss') - sysdate)<0 I still get an error saying "OA-00929: Invalid relational operator". What's wrong with my query and how should I compare the date differences? Thanks! -- Posted via http://dbforums.com      |
|
04-07-2008, 09:24 AM
| ||||
| ||||
| Re: data comparision in Oracle Try it again after removing that ")" trailing the word sysdate abjiang wrote: > > I noticed that the date format is wrong. I've changed the query to > > select * from tableA where to_date(substr(errinfo$datetime, 1, > 19),'yyyy-mm-dd hh24:mi:ss') - sysdate)<0 > > I still get an error saying "OA-00929: Invalid relational operator". > What's wrong with my query and how should I compare the date > differences? > > Thanks! > > -- > Posted via http://dbforums.com |
Linear Mode
