Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_DATE_FORMAT

Re: NLS_DATE_FORMAT

From: Sean McGuire <sean.mcguire_at_external.rrd.com>
Date: Thu, 22 Apr 1999 09:09:42 -0500
Message-ID: <7fn9sa$2uu1@rrdnet20.rrd.com>


Setting NLS_DATE_FORMAT in your init.ora makes little difference. It is ALWAYS the SESSION that determines the format MASK! To figure out the value of your current session:

select * from nls_session_parameters;

It is difficult to change everyone's registry or environment variables, so we decided issue the following when all users connect regardless of their client settings:

alter session set nls_date_format = 'DD-MON-YYYY';

This is the best solution. Remember, this is just a date format, not a y2k fix. Received on Thu Apr 22 1999 - 09:09:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US