Re: Time Zones, How are they handled?

A copy of this was sent to "Bob Fazio" <bob_fazio_at_hotmail.com.no.spam> (if that email address didn't require changing) On Wed, 29 Sep 1999 00:45:30 GMT, you wrote:

>How are time zones handled.
>
>If I insert a row from a PST, and read it from a EST. Do I get a different
>time?
>
>
>

dates in 8.1.5 and before are stored without any timezone information. If you insert 5pm on Jan 1, 2000 into the database in any timezone, you'll get 5pm on Jan 1, 2000 back out in any other timezone.

You can look at using NEW_TIME() to convert times into some base time zone (GMT) on the way in and then back on the way out...

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Sep 29 1999 - 11:54:29 CDT