Gregorian calendar input before 15th October 1582 or after 30th January 4247 is not valid. There was wide variation in the date of adoption of the Gregorian calendar. For example, in Great Britain and colonies, the Julian date Wednesday 2nd September 1752 Old Style was followed the next day by the Gregorian date Thursday 14th September 1752. Oracle is taking the calendar change (Julian->Gregorian) into account.
> -----Original Message----- > From: Hayes, Scott [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 22, 2002 1:19 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle is a time machine!! > > > It must have converted the date to metric. > > -----Original Message----- > Sent: Friday, November 22, 2002 12:55 PM > To: Multiple recipients of list ORACLE-L > > > Don't believe me?? Try this: > > create table test(the_date date); > > insert into test values (to_date('10-05-1582','mm-dd-yyyy') ); > > select to_char(the_date, 'mm/dd/yyyy') from test; > > What do you get? :-)) > > Robert G. Freeman - Oracle OCP > Oracle Database Architect > CSX Midtier Database Administration > Author of several Oracle books you can find on Amazon.com! > > Londo Mollari: Ah, arrogance and stupidity all in the same > package. How > efficient of you. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hayes, Scott > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
