Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date
Hmmm... And where can I adjust the NLS_DATE_FORMAT Parameter?
"Turkbear" <john.greco_at_dot.state.mn.us> schrieb im Newsbeitrag
news:4c04mvcrv88662ivfa9tv2f4jno4svd3p8_at_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
> >
>
> 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:40:46 CDT
![]() |
![]() |