Re: Year 2000

From: Steve White <steve.white_at_gecm.com>
Date: 1997/04/16
Message-ID: <335489D6.6B96@gecm.com>#1/1

Michael Pasternak wrote:
>
> Oracle appears to always default to 1900 if you give it a two digit
> year.
>
> Mike
>

I understood that 'YY' date format was _meant_ to default to '19YY'. Try looking up the 'RR' date format - this gives dates in the range 1950 < 2050 (or 2049? whatever!).

-- 
Steve White
Database Developer/Administrator
Gnet 841-6301
steve.white_at_gecm.com
GMRDS-Portsmouth Information Systems Group

Received on Wed Apr 16 1997 - 00:00:00 CDT