Re: Boundary of date in Oracle?

From: Clif Blanchard <clif_at_onr.com>
Date: 1997/11/21
Message-ID: <3475CFE2.A3E61B4D_at_onr.com>#1/1


ªü´ö 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

  Oracle can handle any date from 01, 01, 4712 b.c to 12, 31, 4712 a.d. Received on Fri Nov 21 1997 - 00:00:00 CET

Original text of this message