Year 2000 question - Oracle 8.0.4.0.0

From: Russell Fray <russ_at_u-net.net>
Date: Wed, 12 Aug 1998 14:48:32 GMT
Message-ID: <35d1aa99.91326723@news.u-net.com>

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. Received on Wed Aug 12 1998 - 09:48:32 CDT