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: NLS_DATE_FORMAT - Now what!!@!!!

Re: NLS_DATE_FORMAT - Now what!!@!!!

From: Michael Pelzelmeyer <mikepelz_at_netway.at>
Date: 1998/02/05
Message-ID: <34D98031.21F9@netway.at>#1/1

Jordan Redner wrote:
>
> Why does everything with Oracle seem to be like pulling teeth?
>
> Probably because I don't know what the hell I'm doing yet.
>
> But anyway....Can someone help me?
>
> The NLS_DATE_FORMAT
>
> seems to work like a champ via the ALTER SESSION command.
>
> i.e.
>
> ALTER SESSION SET NLS_DATE_FORMAT = "mm-dd-yy"
>
> But when I put it in my initXXXX.ora file - it doesn't work
> for squat.
>
> I even do a show parameter NLS_DATE_FORMAT and it looks like it
> got set, yet when I do a
>
> select sysdate from dual;
>
> It still spits out the lame date format 04-Feb-98
>
> When I did the alter session command above, I got a nice
> 02-04-1998
>
> Any help or guidance is greatly appreciated.
>
> Thanks in advance,
>
> Please responsd jordan_at_webnex.com
>
> Jordan

Hi Jordan,
you didn't mention in what environment (Win, UNIX, ...) you did the SELECT.
Depending on the platform, there may be settings that influence the date format.
Win: Registry settings
UNIX: environment variables
variables/settings: NLS_LANG -> NLS_DATE_FORMAT defaults according to the

                                   selected language
                    NLS_DATE_FORMAT

HTH
Michael Received on Thu Feb 05 1998 - 00:00:00 CST

Original text of this message

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