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: Turkbear <john.greco_at_dot.state.mn.us>
Date: Fri, 12 Sep 2003 13:16:13 -0500
Message-ID: <1334mv8ua32if3v6ndp0k7l93ftq8sbb28@4ax.com>

IIRC, This is easier said than done, depending on the Client OS's involved..

You can place NLS_ parameters in the init<sid>.ora file-.

However:
If ANY NLS_ parameters are set on the CLIENT machine ( at least with Windows Registry settings) ALL NLS_ parameters that are not explicitly set there will be set to DEFAULT values regardless of the instance-wide ( init<sid>.ora) setting.

"Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> wrote:

>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 - 13:16:13 CDT

Original text of this message

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