Re: timezone ?

Perry,

Pls read the following: (that copy from the site http://aqueduct.mwd.dst.ca.us:3500/ows-adoc/docs/cart/plaguse.htm)

owa_init Package
This package contains functions and procedures that initialize the cartridge. It also provides constants that you override to set the time zone used by cookies. Cookies use expiration dates defined in Greenwich Mean Time (GMT). If you are not on GMT, you can specify your time zone using one of these two constants:

If your time zone is recognized by Oracle, you can specify it directly using dbms_server_timezone. The value for this is a string abbreviation for your time zone. See chapter 3 of the Oracle7 Server SQL Reference under "SQL Functions" for a list of recognized time zones.

     dbms_server_timezone constant varchar2(3) := `PST'

If your time zone is not recognized by Oracle, use dbms_server_gmtdiff to specify the offset of your time zone from GMT. Specify a positive number if your time zone is ahead of GMT, otherwise negative.

     dbms_server_gmtdiff constant number := NULL

After making the appropriate changes, you need to reload the package.

OR read the official article at
http://technet.oracle.com/doc/websvr2x/web21/psqlwt19.htm

Hope I am helpful this time!

Chadwick

perry ¼g¹D¡G

> 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 Tue Apr 11 2000 - 00:00:00 CDT