How can I compare a date in SQL?

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 - 07:08:05 CEST