Re: Year 2000 question - Oracle 8.0.4.0.0

There are ( at least ) 2 places that set this....

On the Server side - for the database - its in the init<sid>.ora file ( where <sid> is your sid )
NLS_DATE_FORMAT = 'DD-MON-YYYY' will cause the default date format to be 23-MAY-1997 type.....

However,

If the client has a setting for this in its registry ( Win95,WinNT) or Oracle.ini ( Win3.1) the CLIENT format will prevail and will cause all other unspecified NLS_ parameters ( that is,those not in the client registry ) to be set to their default values, even if they are defined in your init<sid>.ora -

So,

either make sure that all your clients have the same NLS_ parameters as your init<sid>.ora OR that they have NO NLS_ parameters set.....

Hope it helps,
John Greco
 Oracle DBA
(Remove the usual to reply)

russ_at_u-net.net (Russell Fray) wrote:

>
>Hi,
>
>I am using Oracle 8.0.4.0.0 and ama little concerend (confused?) about
>the way that dates are displayed in tables.
>
>If I use an SQL statement to extract date-data from a table, the
>format is always :
>
>dd-mon-yy (ie, 17-JUN-97).
>
>I can easily convert this to a 4 digit year using the format command,
>but my question is this - why is the date being displayed by default
>as a 2 digit year?
>
>I would feel much more comfortable if it was by default a 4 digit
>year.... any suggestions?
>
>Please cc replies to russ_at_u-net.net if possible.
>
>Thanks,
>Russ.

To reply please remove the 'nospam' part of the address Received on Thu Aug 13 1998 - 09:22:20 CDT