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