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?
>

1. You could not input a date of '01' in YYYY format You would have to specify the full year. i.e. '2001'
2. YY format always assumes the current century.
3. There is an RR format which is a sliding window between XX50 - X(X+1)49 which allows you to keep the two-digit year format.

It is easiest to stick to the YYYY format. Received on Fri Nov 21 1997 - 00:00:00 CET