Re: Time zones calculation - browser apps

From: Jeremy <jeremy0505_at_gmail.com>
Date: Wed, 27 May 2009 17:28:42 +0100
Message-ID: <MPG.24877a987436e567989729_at_News.Individual.NET>

In article <0a2ebcbe-fa05-4d5a-b619-a0f7e83dd895 _at_r31g2000prh.googlegroups.com>, joel-garry_at_home.com says...> >
> > Thanks for the info, though I hope our environment is simpler - there is
> > no client (per se) as it is simply XHTML -> browser - so the data
> > presented to the user is always generated by PL/SQL in the database.
> > There is no Java layer in there either. Does that simplify things for
> > me?
> >
>
> Probably. Do the research. One way or another you'll have to know
> where the client is coming from, or hope they understand GMT. It may
> be as simple as presenting them with a persistent setup for them to
> choose. I would be concerned about not being on a recent patchset.
>

We are elsewhwere, though this is just a dev database.

We can setup for each user the timezone or say a GMT offset so that's not really a problem. It's really just a case of understanding (I think) whether e.g.

tz_offset('CET')

will give a value of +2 in the summer and +1 in the winter...if not then we need to know whether at "sysdate" whether we are running in daylight savings mode so that we know whether to, in apps code, compensate by +/- 1 hour.

Many thanks for your comments.

-- 
jeremy

Received on Wed May 27 2009 - 11:28:42 CDT