Re: timezone ?

Chadwick Leung <poleetea_at_hotmail.com> wrote in message news:38F20D48.9574D382_at_hotmail.com...
> Oh~, sorry, i misunderstand your question!
>
> I think Oracle refers to the timezone of the OS, agree?
>

I don't know, and I can't find any documentation. I'm starting to suspect that Oracle has no concept of local timezone (being as how you must specify the local timezone in the new_time function).

Look at it this way.

If I enter a time into my server while I'm standing at GMT+6, then pick up the server and walk over to GMT+8, and pull it out, what comes out ?

Did Oracle just store the raw time with no timezone, and will it just pull it out directly, so I'll get back what I put in ?

Or did Oracle look at the local timezone going in, or coming out, or both, and what will I get coming out ?

Eg, if Oracle looked at the local timezone going in, and stored it in GMT, then looked at it coming out, and converted, then I'll get it relative to the
new timezone...

This seems like a fundamental question, and probably an RTFM, but I can't find the M, or the place in the M - I'll check any suggestions tho! :)

>
>
> perry ¼g¹D¡G
>
> > If I put a date into oracle, is it stored as I specified it, or is it
> > converted
> > from my "local" timezone to another (eg, GMT), before it is saved ?
> >
> > Does Oracle have a concept of local timezone ?
> >
> > (I noticed that new_time seems to imply there is no predefined local
> > timezone, as you specify it for each call to new_time)
> >
> > Thanks for any info...
> >
> > - Perry
>
Received on Mon Apr 10 2000 - 00:00:00 CDT