Re: How can I compare a date in SQL?

The default date format for Oracle is DD-MON-YY,

so

Select * from Order where start_date >= '01-JAN-02'

should work.

>Hi
>
>I am a newbie to Oracle. I really need someone to help me.
>I got a SQL statement which try to select all the records with
>start_date >= 01-Jan-2001 from a table in Oracle.
>However, I do not know the exact format of the SQL statement.
>My SQL statement is list as below
>
>Select * from Order where start_date >= 01-01-2001
>
>However, it did not work.
>I have been searching the Web for article to help, however, I could not
>find anything.
>
>Please help.
>
>Best regards
>David Lau
Received on Sat Oct 19 2002 - 21:56:43 CEST