Re: Default Date Format...

In article <3A71889D.5C14909B_at_cern.ch>,
  Erika.Grondzakova_at_cern.ch wrote:
> Hello,
>
> alter session
>
> SQL> alter session set nls_date_format='DD-MON-YYYY';
>
> SQL> select sysdate from dual;
>
> SYSDATE
> -----------
> 26-JAN-2001
>
> Hth,
>
> Erika
>
> "The Tentative DBA...." wrote:
> >
> > I'm just experimenting with the default date format on an 8.1.6 test
> > database here and adjusting the init parameter NLS_DATE_FORMAT. I
 had
> > been under the impression that if I adjusted the parameter then the
> > default date specification for the database followed. It appears
 not to
> > be that simple. I must be missing something very simple !
> >
> > SVRMGR> show parameter nls_date_format;
> > NAME TYPE VALUE
> > ----------------------------------- -------
> > ------------------------------
> > nls_date_format string DD-MON-
> > YYYY
> > SVRMGR> select sysdate from dual;
> > SYSDATE
> > ---------
> > 26-JAN-01
> > 1 row selected.
> > SVRMGR> select to_char(sysdate) from dual;
> > TO_CHAR(S
> > ---------
> > 26-JAN-01
> > 1 row selected.
> > SVRMGR>
> > --
> >
> > Sent via Deja.com
> > http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 10:14:23 CST