Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: data comparision in Oracle

Re: data comparision in Oracle

From: Bricklen <nope_at_nope.com>
Date: Tue, 12 Aug 2003 17:55:14 GMT
Message-ID: <3F392BBE.1DF9B2DD@nope.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US