Re: Different clocks for different instances.
Resending. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd - Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on 19/12/2001 11:49 AM - Change the TZ variable in the Unix environment and restart the instance. My guess is that it should work. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Kevin Pollard <[EMAIL PROTECTED]> 19/12/2001 10:50 AM Sent by: [EMAIL PROTECTED] Gooday Oraclers, is it possible to have different instances, on the same dB server, operating with different clocks - ie different date/times? Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20 --- Kevin Pollard | PODBA (Pretend Oracle DBA) mailto:[EMAIL PROTECTED] | Administrative Systems Unit Phone:+61 (02) 6620 3969 | Southern Cross University FAX:+61 (02) 6626 9122 | P.O. Box 157 Room: R1-40a | Lismore NSW 2480, Australia http://staff.scu.edu.au/asu/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Pollard INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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).
RE: Different clocks for different instances.
Oracle uses the system clock. So I would have to say no. -Original Message- Pollard Sent: Tuesday, December 18, 2001 6:50 PM To: Multiple recipients of list ORACLE-L Gooday Oraclers, is it possible to have different instances, on the same dB server, operating with different clocks - ie different date/times? Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20 --- Kevin Pollard | PODBA (Pretend Oracle DBA) mailto:[EMAIL PROTECTED] | Administrative Systems Unit Phone:+61 (02) 6620 3969 | Southern Cross University FAX:+61 (02) 6626 9122 | P.O. Box 157 Room: R1-40a | Lismore NSW 2480, Australia http://staff.scu.edu.au/asu/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Pollard INET: [EMAIL PROTECTED] 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: [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: Kimberly Smith INET: [EMAIL PROTECTED] 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: [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).
Mabye OT: Was Re: Different clocks for different instances.
Speaking of the system clock, here's something interesting that I stumbled across a few years back... Background: For those of you who may not know, the Julian calendar was abandoned by England, in favor of the Gregorian calendar, in 1752 because of date discrepancies. To facilitate this, September 3 - 13 were eliminated. This is actually reflected in UNIX (well, Solaris anyway) by issuing the 'cal 1752' command and looking at the month of September: Jul Aug Sep S M Tu W Th F S S M Tu W Th F S S M Tu W Th F S 1 2 3 4 1 1 2 14 15 16 5 6 7 8 9 10 11 2 3 4 5 6 7 8 17 18 19 20 21 22 23 12 13 14 15 16 17 18 9 10 11 12 13 14 15 24 25 26 27 28 29 30 19 20 21 22 23 24 25 16 17 18 19 20 21 22 26 27 28 29 30 31 23 24 25 26 27 28 29 More info. on why the switch over occurred is available at http://www.bicknell.net/books/pc1981/p_calender.htm, for those of you with morbid curiosity. Anyway - I was doing some Y2K testing a few years back, and playing with NLS_DATE_FORMAT queries when I learned this little tidbit. I decided to test the Oracle date formats because - hey - they'll be okay because they're based on Unix, right? Wrong: Issue the following query: select sysdate ,add_months(sysdate,-2988) ,add_months(sysdate,-2988) - 10 from dual; And see the following results: SYSDATE ADD_MONTHS(SYSDATE,- ADD_MONTHS(SYSDATE,- 19-DEC-2001 10:07:02 19-DEC-1752 10:07:02 09-DEC-1752 10:07:02 The third column represents a date which, technically, does not exist. : ) Brian Kimberly Smith wrote: Oracle uses the system clock. So I would have to say no. -Original Message- Pollard Sent: Tuesday, December 18, 2001 6:50 PM To: Multiple recipients of list ORACLE-L Gooday Oraclers, is it possible to have different instances, on the same dB server, operating with different clocks - ie different date/times? Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20 --- Kevin Pollard | PODBA (Pretend Oracle DBA) mailto:[EMAIL PROTECTED] | Administrative Systems Unit Phone:+61 (02) 6620 3969 | Southern Cross University FAX:+61 (02) 6626 9122 | P.O. Box 157 Room: R1-40a | Lismore NSW 2480, Australia http://staff.scu.edu.au/asu/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Pollard INET: [EMAIL PROTECTED] 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: [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: Kimberly Smith INET: [EMAIL PROTECTED] 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: [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). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | --
RE: Mabye OT: Was Re: Different clocks for different instances.
Well I
say,
that
is also the case on Tru64 as well.
How
pedantic is UNIX ??
-Original Message-From: Brian McGraw
[mailto:[EMAIL PROTECTED]]Sent: 19 December 2001
16:16To: Multiple recipients of list ORACLE-LSubject:
Mabye OT: Was Re: Different clocks for different
instances.Speaking of the system clock, here's something
interesting that I stumbled across a few years back...
Background: For those of you who may not know, the Julian calendar
was abandoned by England, in favor of the Gregorian calendar, in 1752 because
of date discrepancies. To facilitate this, September 3 - 13 were
eliminated. This is actually reflected in UNIX (well, Solaris anyway) by
issuing the 'cal 1752' command and looking at the month of September:
Jul
Aug
Sep S M Tu W Th F
S S M Tu W Th F S
S M Tu W Th F S
1 2
3
4
1 1 2 14 15
16 5 6 7 8 9 10
11 2 3 4 5 6 7
8 17 18 19 20 21 22 23 12 13 14 15 16 17
18 9 10 11 12 13 14 15 24 25 26 27 28 29 30
19 20 21 22 23 24 25 16 17 18 19 20 21 22 26
27 28 29 30 31 23 24 25 26 27 28 29
More info. on why the switch over occurred is available at http://www.bicknell.net/books/pc1981/p_calender.htm,
for those of you with morbid curiosity.
Anyway - I was doing some Y2K testing a few years back, and playing with
NLS_DATE_FORMAT queries when I learned this little tidbit. I decided to
test the Oracle date formats because - hey - they'll be okay because they're
based on Unix, right?
Wrong: Issue the following query:
select sysdate
,add_months(sysdate,-2988)
,add_months(sysdate,-2988) - 10 from dual;
And see the following results:
SYSDATE
ADD_MONTHS(SYSDATE,- ADD_MONTHS(SYSDATE,-
19-DEC-2001 10:07:02
19-DEC-1752 10:07:02 09-DEC-1752 10:07:02
The third column represents a date which, technically, does not
exist. : )
Brian
Kimberly Smith wrote:
Oracle uses the system clock. So I would have
to say no.
-Original Message- Pollard Sent: Tuesday, December 18,
2001 6:50 PM To: Multiple recipients of list ORACLE-L
Gooday Oraclers, is it possible to have different instances, on the
same dB server, operating with different clocks - ie different
date/times?
Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20
---
Kevin Pollard | PODBA (Pretend Oracle DBA) mailto:[EMAIL PROTECTED]
| Administrative Systems Unit Phone:+61 (02)
6620 3969 | Southern Cross University
FAX:+61 (02) 6626 9122 | P.O.
Box 157
Room: R1-40a | Lismore NSW 2480, Australia
http://staff.scu.edu.au/asu/index.html
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
Kevin Pollard INET: [EMAIL PROTECTED]
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: [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:
Kimberly Smith INET: [EMAIL PROTECTED]
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: [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).-- --
| Brian McGraw -- Oracle
DBA | | Central Alabama Oracle Users Group |
|| | mailto:[EMAIL PROTECTED]
| | http://bmcgraw.home.mindspring.com
| --
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this co
Re: Mabye OT: Was Re: Different clocks for different instances.
Brian McGraw wrote: > > Speaking of the system clock, here's something interesting that I > stumbled across a few years back... > > Background: For those of you who may not know, the Julian calendar > was abandoned by England, in favor of the Gregorian calendar, in 1752 > because of date discrepancies. To facilitate this, September 3 - 13 > were eliminated. This is actually reflected in UNIX (well, Solaris > anyway) by issuing the 'cal 1752' command and looking at the month of > September: > > JulAugSep > S M Tu W Th F SS M Tu W Th F SS M Tu W Th F S > 1 2 3 4 1 1 2 14 15 16 > 5 6 7 8 9 10 112 3 4 5 6 7 8 17 18 19 20 21 22 23 > 12 13 14 15 16 17 189 10 11 12 13 14 15 24 25 26 27 28 29 30 > 19 20 21 22 23 24 25 16 17 18 19 20 21 22 > 26 27 28 29 30 31 23 24 25 26 27 28 29 > > More info. on why the switch over occurred is available at > http://www.bicknell.net/books/pc1981/p_calender.htm, for those of you > with morbid curiosity. > > Anyway - I was doing some Y2K testing a few years back, and playing > with NLS_DATE_FORMAT queries when I learned this little tidbit. I > decided to test the Oracle date formats because - hey - they'll be > okay because they're based on Unix, right? > > Wrong: Issue the following query: > > select sysdate > ,add_months(sysdate,-2988) > ,add_months(sysdate,-2988) - 10 > from dual; > > And see the following results: > > SYSDATE ADD_MONTHS(SYSDATE,- ADD_MONTHS(SYSDATE,- > > 19-DEC-2001 10:07:02 19-DEC-1752 10:07:02 09-DEC-1752 10:07:02 > > The third column represents a date which, technically, does not > exist. : ) > > Brian > Brian, Speak for yourself. The continent, much more enlightened, had switched in October 1582. England had opted out, as it seems, and jumped on the bandwagon belatedly (sounds furiously modern, doesn't it?). Check within Oracle the number of days in October 1582, you will see that it's correct (from my point of view). I don't think that you can say that the Oracle date is based on the system date for these dates, because Unix systems only see dark ages before 1st Jan 1970. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [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).
RE: Mabye OT: Was Re: Different clocks for different instances.
Oracle uses the original start date of the Gregorian calendar in October
1582:
1* select to_date('04-OCT-1582'), to_date('04-OCT-1582')+1 from dual
devp> /
TO_DATE('04-OCT-1582 TO_DATE('04-OCT-1582
04-OCT-1582 00:00:00 15-OCT-1582 00:00:00
Ben Schilling
Telecomm Manager
Office of the Commissioner of Insurance
608-266-1615 [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, December 19, 2001 11:09 AM
To: Multiple recipients of list ORACLE-L
Well I say,
that is also the case on Tru64 as well.
How pedantic is UNIX ??
-Original Message-
Sent: 19 December 2001 16:16
To: Multiple recipients of list ORACLE-L
Speaking of the system clock, here's something interesting that I stumbled
across a few years back...
Background: For those of you who may not know, the Julian calendar was
abandoned by England, in favor of the Gregorian calendar, in 1752 because of
date discrepancies. To facilitate this, September 3 - 13 were eliminated.
This is actually reflected in UNIX (well, Solaris anyway) by issuing the
'cal 1752' command and looking at the month of September:
JulAugSep
S M Tu W Th F SS M Tu W Th F SS M Tu W Th F S
1 2 3 4 1 1 2 14 15 16
5 6 7 8 9 10 112 3 4 5 6 7 8 17 18 19 20 21 22 23
12 13 14 15 16 17 189 10 11 12 13 14 15 24 25 26 27 28 29 30
19 20 21 22 23 24 25 16 17 18 19 20 21 22
26 27 28 29 30 31 23 24 25 26 27 28 29
More info. on why the switch over occurred is available at
http://www.bicknell.net/books/pc1981/p_calender.htm
, for those of you
with morbid curiosity.
Anyway - I was doing some Y2K testing a few years back, and playing with
NLS_DATE_FORMAT queries when I learned this little tidbit. I decided to
test the Oracle date formats because - hey - they'll be okay because they're
based on Unix, right?
Wrong: Issue the following query:
select sysdate
,add_months(sysdate,-2988)
,add_months(sysdate,-2988) - 10
from dual;
And see the following results:
SYSDATE ADD_MONTHS(SYSDATE,- ADD_MONTHS(SYSDATE,-
19-DEC-2001 10:07:02 19-DEC-1752 10:07:02 09-DEC-1752 10:07:02
The third column represents a date which, technically, does not exist. : )
Brian
Kimberly Smith wrote:
Oracle uses the system clock. So I would have to say no.
-Original Message-
Pollard
Sent: Tuesday, December 18, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L
Gooday Oraclers,
is it possible to have different instances, on the same dB server,
operating with different clocks - ie different date/times?
Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20
---
Kevin Pollard | PODBA (Pretend Oracle DBA)
mailto:[EMAIL PROTECTED] |
Administrative Systems Unit
Phone:+61 (02) 6620 3969 | Southern Cross University
FAX:+61 (02) 6626 9122 | P.O. Box 157
Room: R1-40a | Lismore NSW 2480, Australia
http://staff.scu.edu.au/asu/index.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Pollard
INET: [EMAIL PROTECTED]
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: [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: Kimberly Smith
INET: [EMAIL PROTECTED]
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: [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).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com
Re: Mabye OT: Was Re: Different clocks for different instances.
Wel. I feel enlightened.
And more secure! Now the Y1752 / Y1582 bugs won't bite me either! : )
"Schilling, Ben" wrote:
> Oracle uses the original start date of the Gregorian calendar in October
> 1582:
>
> 1* select to_date('04-OCT-1582'), to_date('04-OCT-1582')+1 from dual
> devp> /
>
> TO_DATE('04-OCT-1582 TO_DATE('04-OCT-1582
>
> 04-OCT-1582 00:00:00 15-OCT-1582 00:00:00
> Ben Schilling
> Telecomm Manager
> Office of the Commissioner of Insurance
> 608-266-1615 [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Wednesday, December 19, 2001 11:09 AM
> To: Multiple recipients of list ORACLE-L
>
> Well I say,
>
> that is also the case on Tru64 as well.
>
> How pedantic is UNIX ??
>
>
> -Original Message-
> Sent: 19 December 2001 16:16
> To: Multiple recipients of list ORACLE-L
>
> Speaking of the system clock, here's something interesting that I stumbled
> across a few years back...
>
> Background: For those of you who may not know, the Julian calendar was
> abandoned by England, in favor of the Gregorian calendar, in 1752 because of
> date discrepancies. To facilitate this, September 3 - 13 were eliminated.
> This is actually reflected in UNIX (well, Solaris anyway) by issuing the
> 'cal 1752' command and looking at the month of September:
>
> JulAugSep
> S M Tu W Th F SS M Tu W Th F SS M Tu W Th F S
> 1 2 3 4 1 1 2 14 15 16
> 5 6 7 8 9 10 112 3 4 5 6 7 8 17 18 19 20 21 22 23
> 12 13 14 15 16 17 189 10 11 12 13 14 15 24 25 26 27 28 29 30
> 19 20 21 22 23 24 25 16 17 18 19 20 21 22
> 26 27 28 29 30 31 23 24 25 26 27 28 29
>
> More info. on why the switch over occurred is available at
> http://www.bicknell.net/books/pc1981/p_calender.htm
> , for those of you
> with morbid curiosity.
>
> Anyway - I was doing some Y2K testing a few years back, and playing with
> NLS_DATE_FORMAT queries when I learned this little tidbit. I decided to
> test the Oracle date formats because - hey - they'll be okay because they're
> based on Unix, right?
>
> Wrong: Issue the following query:
>
> select sysdate
> ,add_months(sysdate,-2988)
> ,add_months(sysdate,-2988) - 10
> from dual;
>
> And see the following results:
>
> SYSDATE ADD_MONTHS(SYSDATE,- ADD_MONTHS(SYSDATE,-
>
> 19-DEC-2001 10:07:02 19-DEC-1752 10:07:02 09-DEC-1752 10:07:02
>
> The third column represents a date which, technically, does not exist. : )
>
> Brian
>
> Kimberly Smith wrote:
>
> Oracle uses the system clock. So I would have to say no.
>
> -Original Message-
> Pollard
> Sent: Tuesday, December 18, 2001 6:50 PM
> To: Multiple recipients of list ORACLE-L
>
> Gooday Oraclers,
> is it possible to have different instances, on the same dB server,
> operating with different clocks - ie different date/times?
>
> Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20
>
> ---
>Kevin Pollard | PODBA (Pretend Oracle DBA)
> mailto:[EMAIL PROTECTED] |
> Administrative Systems Unit
> Phone:+61 (02) 6620 3969 | Southern Cross University
> FAX:+61 (02) 6626 9122 | P.O. Box 157
> Room: R1-40a | Lismore NSW 2480, Australia
> http://staff.scu.edu.au/asu/index.html
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>
> --
> Author: Kevin Pollard
> INET: [EMAIL PROTECTED]
>
> 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: [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: Kimberly Smith
> INET: [EMAIL PROTECTED]
>
> 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: [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).
>
>
RE: Mabye OT: Was Re: Different clocks for different instances.
Ah, but check 10/5-16/1582 for Oracle. That is when the Gregorian calandar was adopted. 1752 is just for England (I believe). Henry -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 19, 2001 12:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Mabye OT: Was Re: Different clocks for different instances. Well I say, that is also the case on Tru64 as well. How pedantic is UNIX ?? -Original Message-From: Brian McGraw [mailto:[EMAIL PROTECTED]]Sent: 19 December 2001 16:16To: Multiple recipients of list ORACLE-LSubject: Mabye OT: Was Re: Different clocks for different instances.Speaking of the system clock, here's something interesting that I stumbled across a few years back... Background: For those of you who may not know, the Julian calendar was abandoned by England, in favor of the Gregorian calendar, in 1752 because of date discrepancies. To facilitate this, September 3 - 13 were eliminated. This is actually reflected in UNIX (well, Solaris anyway) by issuing the 'cal 1752' command and looking at the month of September: Jul Aug Sep S M Tu W Th F S S M Tu W Th F S S M Tu W Th F S 1 2 3 4 1 1 2 14 15 16 5 6 7 8 9 10 11 2 3 4 5 6 7 8 17 18 19 20 21 22 23 12 13 14 15 16 17 18 9 10 11 12 13 14 15 24 25 26 27 28 29 30 19 20 21 22 23 24 25 16 17 18 19 20 21 22 26 27 28 29 30 31 23 24 25 26 27 28 29 More info. on why the switch over occurred is available at http://www.bicknell.net/books/pc1981/p_calender.htm, for those of you with morbid curiosity. Anyway - I was doing some Y2K testing a few years back, and playing with NLS_DATE_FORMAT queries when I learned this little tidbit. I decided to test the Oracle date formats because - hey - they'll be okay because they're based on Unix, right? Wrong: Issue the following query: select sysdate ,add_months(sysdate,-2988) ,add_months(sysdate,-2988) - 10 from dual; And see the following results: SYSDATE ADD_MONTHS(SYSDATE,- ADD_MONTHS(SYSDATE,- 19-DEC-2001 10:07:02 19-DEC-1752 10:07:02 09-DEC-1752 10:07:02 The third column represents a date which, technically, does not exist. : ) Brian Kimberly Smith wrote: Oracle uses the system clock. So I would have to say no. -Original Message- Pollard Sent: Tuesday, December 18, 2001 6:50 PM To: Multiple recipients of list ORACLE-L Gooday Oraclers, is it possible to have different instances, on the same dB server, operating with different clocks - ie different date/times? Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20 --- Kevin Pollard | PODBA (Pretend Oracle DBA) mailto:[EMAIL PROTECTED] | Administrative Systems Unit Phone:+61 (02) 6620 3969 | Southern Cross University FAX:+61 (02) 6626 9122 | P.O. Box 157 Room: R1-40a | Lismore NSW 2480, Australia http://staff.scu.edu.au/asu/index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Pollard INET: [EMAIL PROTECTED] 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: [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: Kimberly Smith INET: [EMAIL PROTECTED] 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: [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
