Re: Display of system date in oracle.

I bet you are using different settings for NLS_LANG.

The date format NLS_DATE_FORMAT is derrived from the territory and since NLS_LANG is made up of NLS_LANGUAGE, NLS_TERRITORY, and NLS_CHARACTER_SET and the date format for japanese is different than american you will see different settings for NLS_DATE_FORMAT..

What you should do to obtain the same date format is to set NLS_DATE_FORMAT in your client's environment (or in the registry if running on Windoze). Another way (which is more suitable for testing though) is to:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RR' Note that RR is preferred to YY (Y2K issue :-).

Cheers,
Jesper

On Wed, 19 Jan 2000 02:04:03 -0800, Dhanesh <jdhaneshNOjdSPAM_at_yahoo.com.invalid> wrote:

>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 - 12:18:02 CST