Re: Incorrect Oracle Sysdate

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Tue, 05 Nov 2002 12:58:32 -0600
Message-ID: <055gsugjork17ntqsf8nujhq35v92jhdcd@4ax.com>

On Tuesday November 5 at 12:11 I ran this: SQL> select to_char(sysdate,'MM/DD/YYYY HH24:MM') from dual SQL> / TO_CHAR(SYSDATE,

---

11/05/2002 12:11

Look like it reads it.....

Daniel Morgan <dmorgan_at_exesolutions.com> wrote:

>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.
>
>Just a guess. But it would pretty much have to read the system time to
>handle changes such as Daylight Savings Time in the US. Otherwise Oracle
>time could differ from O/S time by as much as an hour.
>
>Daniel Morgan

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Nov 05 2002 - 12:58:32 CST