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: Michel Cadot <micadot2removethat_at_free.fr>
Date: Fri, 12 Sep 2003 20:18:00 +0200
Message-ID: <3f620d14$0$27038$626a54ce@news.free.fr>

"Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> a écrit dans le message de news:bjt189$mk2rh$1_at_uni-berlin.de...
> Sorry, but its not possible for me to use to_date!
> ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'
> only changes the format for the session. i like to change it permanently.

Set NLS_DATE_FORMAT in your parameter file (init.ora or spfile) or set it in the environment of all the clients.

Michel Cadot

>
>
> Harald Maier" <maierh_at_myself.com> schrieb im Newsbeitrag
> news:m3y8wtj3wr.fsf_at_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 - 13:18:00 CDT

Original text of this message

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