Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date
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.
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 - 12:57:06 CDT