Re: Display of system date in oracle.

The default date format display is not the same.

You can change the default date format display by issuing the following in your SQL*PLUS session :

alter session set nls_date_format='DD/MM/YY';

for instance.

Dhanesh <jdhaneshNOjdSPAM_at_yahoo.com.invalid> a écrit dans l'article <0ec4c663.a6f1572d_at_usw-ex0110-076.remarq.com>...
> Hello friends,
> I have a query regarding sysdate.At my work place I have
> my oracle database on a SUN Solaris machine. And I have
> oracle client installed on my machine. The OS is japanese on
> the server as well as my machine.
> When asked for the sysdate the display format is
> 'YY/MM/DD' at the same time my co-worker who is accessing
> the same database but from a english OS is getting the
> display as 'DD-MON-YY'. Since we both are connecting t the
> same server, why is date displayed in different formats.Does
> the difference in OS make it so.
> It would be helpful if this query is solved.
> Thanks
> Dhanesh
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
>
Received on Wed Jan 19 2000 - 04:20:04 CST