Re: Incorrect Oracle Sysdate

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 05 Nov 2002 22:59:18 +0100
Message-ID: <eofgsu03b2ip8l8t41pglfud4rf12hu8em@4ax.com>

On Tue, 05 Nov 2002 11:03:49 -0800, Martin Doherty <martin.doherty_at_oracle.nospam.com> wrote:

>This is a nice little thought experiment. If it isn't coming from the
>hardware clock, where IS Oracle getting the information from?
>
>
>tvf wrote:
>
>>Out of curiosity, does select sysdate actually read from the Unix
>>system time or does it get set when the db is first brought up?
>>
>>Thanks.
>>
>>

On Unix the results will be identical with the results of the date command so compensated for timezone.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Nov 05 2002 - 15:59:18 CST