Re: Date

From: Harald Maier <maierh_at_myself.com>
Date: Fri, 12 Sep 2003 19:46:28 +0200
Message-ID: <m3y8wtj3wr.fsf@ate.maierh>

"Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> writes:

> Hmmm... And where can I adjust the NLS_DATE_FORMAT Parameter?

>> "Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> wrote:
>>
>> > SELECT * FROM T_Test WHERE Start > '1.1.2002'
>> >is running with the correct results.
>> >
>> > SELECT * FROM T_Test WHERE Start > '1.1.2002 1:00:01'
>> >doesnt work.
>> >
>> Setting your NLS_DATE_FORMAT to include the time component should allow
> the second version to work..

You also can use:

,----[ untested code ]
| SELECT * FROM T_Test
| WHERE Start > to_date('1.1.2002 1:00:01', 'dd.mm.yyyy hh24:mi:ss'); `----

Harald Received on Fri Sep 12 2003 - 12:46:28 CDT