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 -
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,
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
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
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
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
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
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]
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
