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
