Re: Boundary of date in Oracle?

ªü´ö Thenardier wrote:
>
> What is the boundary of date that Oracle can handle?
>
> Another question is, the year in a date that displays
> in SQL/Plus is a 2-digit one. When the 2 digits are '01',
> how would Oracle treat that '01' in YYYY format? '1901',
> or '2001'? Then what should i do if i want to force
> Oracle to convert it into a '20YY' date? And what if
> i want it a '19YY' one instead?
>
> Thanx!
>
> Thenard
Thenard:

        You can always force the date...

        to_date('19' || '01','YYYY')

        to_date('20' || <2digit year variable>, 'YYYY')

        or any number of variations....

Mike Krolewski Received on Thu Nov 20 1997 - 00:00:00 CET