Re: Dates in SQL?
From: Kevin Loney <"75663,327"_at_compuserve.com>
Date: 1996/10/15
Message-ID: <3263C13D.6D2B_at_compuserve.com>#1/1
Date: 1996/10/15
Message-ID: <3263C13D.6D2B_at_compuserve.com>#1/1
> I don't know how can the DBA change the default date format ?
> What is the exact method ? Can you help me, please ?
> Does this Default Date format apply to ALL date conversion from Char->Date
> and vice versa as well !
> i.e. if my default date format is 'DD/MM/YYYY' suppose,
> then I can say
> insert into temp (tempdata)
> values ('01/01/1997');
> and Oracle will apply my 'DD/MM/YYYY' default date format instead of
> the usual 'DD-MON-YY' to this !
>
The parameter is NLS_DATE_FORMAT, you can set it via ALTER SESSION or at
the init.ora level.
ALTER SESSION SET NLS_DATE_FORMAT = "dd/mon/yyyy";
-as of Oracle7.2.
-Kevin Received on Tue Oct 15 1996 - 00:00:00 CEST