Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 CST