Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> NLS_DATE_FORMAT on server and client
Hi to everyone.
value contained in the init.ora initialisation file get used (as opposed to
the client's NLS_DATE_FORMAT).
client's value overrides the value in the server for all explicit and
implicit conversions of dates and chars. However, it appears much more
complex than this. I have been reading an Oracle white paper "Date Handling
in Developer 2000" which has left me totally confused on a subject I thought
I had come to grips with. From within Developer 2000 1.5.1, the following 2
statements do vastly different things. Assume Client nls_date_format is set
to DD-MON-YYYY
(to_char(to_date(to_char( (sysdate+365) ) ), 'DD-MON-YYYY') );
yields 01-Feb-2000 which is fine
declare
'DD-MON-YYYY');
course doing the above from sql*plus yields the correct value.
issue of the client and server nls_date_format needs to be explained to me
please. Does it depend on the client software being used etc etc?
enlighten me?
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 01 1999 - 10:20:46 CST