Re: How can I compare a date in SQL?
Date: Sat, 19 Oct 2002 05:20:52 GMT
Message-ID: <UY5s9.5919$%d2.14941_at_sccrnsc01>
You already posted this and it was answered in comp.database.oracle.
I am not typing it again.
Jim
"David Lau" <itdalau_at_yahoo.com> wrote in message
news:54caf24b.0210182108.678ee355_at_posting.google.com...
> 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:20:52 CEST