Re: Date

From: Turkbear <john.greco_at_dot.state.mn.us>
Date: Fri, 12 Sep 2003 12:26:56 -0500
Message-ID: <4c04mvcrv88662ivfa9tv2f4jno4svd3p8@4ax.com>

"Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> wrote:

>
>Hi!
>
>The Query
> SELECT * FROM T_Test WHERE Start > '1.1.2002'
>is running with the correct results.
>
>Using a date with time like
> SELECT * FROM T_Test WHERE Start > '1.1.2002 1:00:01'
>doesnt work.
>
>My problem is that i have to avoid any function like to_date etc.
>
>Thanks,
>Ralf
>

Posting only here ( do not like to cross-post):

Setting your NLS_DATE_FORMAT to include the time component should allow the second version to work..

hth Received on Fri Sep 12 2003 - 12:26:56 CDT