Re: How can I compare a date in SQL?

From: Odd Morten Sveås <odd.morten.sveas_at_accenture.com>
Date: 19 Oct 2002 13:37:09 -0700
Message-ID: <4306a83.0210191237.6f389ccc_at_posting.google.com>


itdalau_at_yahoo.com (David Lau) 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

Have you realy seached the web?

I'd google for: sql oracle date
here in google groups. The second article I hit sould have given you acsactly what you need to understand the string date converion in oracle sql.

Also you could try some documentation. A good place to start would be oracle's web pages.

Regards
Odd M Received on Sat Oct 19 2002 - 22:37:09 CEST

Original text of this message