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
Received on Tue Aug 12 2003 - 12:55:14 CDT
