Re: Display of system date in oracle.

It is how your nls_date_format is set.

The order of highrechy is as follows.
Server has a default NLS_DATE_FORMAT or it is set in initSID.ora SQL*Net or Net8 with a client side format will override the Server setting. An explicit ALTER SESSION SET NLS_DATE_FORMAT will override every other settings. The reason you are getting different settings is because each country have different defaults.

Dhanesh 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 Sat Jan 22 2000 - 20:42:18 CST