Re: Incorrect Oracle Sysdate

I love the classics...except of course my classic errors - Thanks for the pick-up...

"Robbert Van der Hoorn" <rvanderhoorn_at_wanadoo.nl> wrote:

>If you run it at 12:13 you'll get the same answer... Use HH24:MI in stead of
>HH24:MM
>
>It's a classic error...
>
>
>"TurkBear" <john.greco_at_dot.state.mn.us> schreef in bericht
>news:055gsugjork17ntqsf8nujhq35v92jhdcd_at_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 12 2002 - 15:56:24 CST