RE: Oracle is a time machine!!

From: Freeman, Robert <Robert_Freeman_at_csx.com>
Date: Fri, 22 Nov 2002 12:09:51 -0800
Message-ID: <F001.00509B10.20021122120951@fatcity.com>

Actually, I knew that part of it, I was thinking about that last night and wondered how Oracle would handle
a date in that range (which in my mind is an invalid date).  

RF  

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.    

-----Original Message-----
Sent: Friday, November 22, 2002 1:50 PM
To: Multiple recipients of list ORACLE-L

I think this is because during this time Pope Gregory removed 10 days from the calendar to align with solar calendar...

check this out...

http://webexhibits.org/calendars/timeline.html <http://webexhibits.org/calendars/timeline.html>  

>From: "Freeman, Robert"
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L
>Subject: Oracle is a time machine!!
>Date: Fri, 22 Nov 2002 09:55:21 -0800
>
>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: Robert_Freeman_at_csx.com
>
>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: ListGuru_at_fatcity.com (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).

---

STOP MORE SPAM with the new MSN 8 <http://g.msn.com/8HMDEN/2015> and get 2 months FREE* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viral Desai INET: viral303_at_hotmail.com 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: ListGuru_at_fatcity.com (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: Freeman, Robert
  INET: Robert_Freeman_at_csx.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Nov 22 2002 - 14:09:51 CST