okay, time to nip this discussion in the bud....... First of all, there are/were 2 calendar systems. The gregorian and the juilan calendars. They both got out of synch with the seasons (due to no leap year or something). They were both adjusted forward a number of days to synch back up the real world.. One of them (the one Oracle uses) just so happened to jump forward in October 1582. The other one (used by UNIX) on a different date.
Read about it here...http://serendipity.magnet.ch/hermetic/cal_stud.htm -----Original Message----- Sent: Friday, November 22, 2002 1:19 PM To: Multiple recipients of list ORACLE-L 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: Toepke, Kevin M 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).
