Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Date

Re: Date

From: Ralf Schnickmann <ralf_schnickmann_at_gmx.de>
Date: Fri, 12 Sep 2003 19:40:46 +0200
Message-ID: <bjt09l$m9hvn$1@uni-berlin.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US