RE: DATE 5th OCT, 1582 not coming

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Wed, 18 Oct 2000 12:59:31 +0400
Message-Id: <10653.119605@fatcity.com>

There is a conflict ( if not deadlock).....
>>>

SQL> select to_date('10-Oct-1582','dd-Mon-yyyy') from dual ;

TO_DATE('10

15-OCT-1582 SQL> select to_date('10-Sep-1752','dd-Mon-yyyy') from dual;

TO_DATE('10

10-SEP-1752
<<<

I can also say Oracle is perfect
(at least this time) <grin> ;-))

After all we were not there in 1582 or
1752 <grin again>....

Rajesh

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Arul kumar Sent: Wednesday, October 18, 2000 12:06 PM To: Multiple recipients of list ORACLE-L Subject: Re: DATE 5th OCT, 1582 not coming

Hi Rajesh,

The result doesn't mean UNIX is not showing the correct dates. It is showing the correct dates only.
For the month of September , 1752 it is officially announced at that time
like that
(for adjustments in Leap Year calc. ) .

UNIX is Perfect.

Arul.

Rajesh Dayal wrote:

> Unix says a diff version of story..........
>
> oracle81 REP2> cal 10 1582
>
> October 1582
> Sun Mon Tue Wed Thu Fri Sat
> 1 2 3 4 5 6
> 7 8 9 10 11 12 13
> 14 15 16 17 18 19 20
> 21 22 23 24 25 26 27
> 28 29 30 31
>
> oracle81 REP2> cal 09 1752
>
> September 1752
> Sun Mon Tue Wed Thu Fri Sat
> 1 2 14 15 16
> 17 18 19 20 21 22 23
> 24 25 26 27 28 29 30
>
> I don't know whom to trust :-||
>
> Rajesh
>
> -----Original Message-----
> Pierce
> Sent: Wednesday, October 18, 2000 6:11 AM
> To: Multiple recipients of list ORACLE-L
>
> Does that mean that unix is wrong?
> ep
>
> On 17 Oct 2000, at 14:21, Jamadagni, Rajendra wrote:
>
> Date sent: Tue, 17 Oct 2000 14:21:32 -0800
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Send reply to: ORACLE-L_at_fatcity.com
>
> > oops .....
> >
> > Too much or too little coffee ....
> >
> > sorry about the confusion ..
> > But check this out ....
> >
> > [174]/home/jamadagr/debug> cal 10 1582
> > October 1582
> > S M Tu W Th F S
> > 1 2 3 4 5 6
> > 7 8 9 10 11 12 13
> > 14 15 16 17 18 19 20
> > 21 22 23 24 25 26 27
> > 28 29 30 31
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eric D. Pierce
> INET: PierceED_at_csus.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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: Arul kumar
  INET: rakumar_at_mahindrabt.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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

Received on Wed Oct 18 2000 - 03:59:31 CDT