Re: How can I compare a date in SQL?
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