Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_DATE_FORMAT
set NLS_DATE_FORMAT as env var, or in hklm\software\oracle on the client, or (8i and beyond) use an after logon trigger to issue execute immediate 'alter session set nls_date_format ...'
Hth,
Sybrand Bakker, Oracle DBA
<subrar_at_my-deja.com> wrote in message news:8uvif1$cv9$1_at_nnrp1.deja.com...
> Hi,
> I need to change the date format to 'dd/mm/yyyy hh24:mi:ss'
> I changed in init.ora parameters
> shutdown and startup the oracle instance .
> but it if i select sysdate from dual
> the format is
> dd-MON-yy
> but i need the format 'dd/mm/yyyy hh24:mi:ss'
>
> please help in this issue
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 16 2000 - 00:36:49 CST