Re: Timezone changes

> I'm running on different platforms, which can be in any timezone. In
> all cases, I need to determine the current time in US Eastern Timezone,
> accounting for daylight savings (i.e. as in EST5EDT on UNIX). I see the
> new_time function can be used as:
> select new_time(sysdate,'GMT','EST')
> and the valid values for 'other timezone' are:
> AST for Atlantic standard time
> ADT for Atlantic Daylight savings time
> EST for Eastern standard time
> EDT for Eastern Daylight savings time
> CST for Central standard time, etc.
> How can I determine the cuurent Eastern Timezone time, accounting
> for daylight savings?

It is more complicated than you think. Some states do not go on Daylight Savings Time or rather than going onto Daylight Savings Time change time zones. I think Arizona is one. I think you may find it necessary to build a table depending on what states are of interest and what parts of what states are of interest.

Daniel A. Morgan Received on Wed Jan 24 2001 - 22:50:40 CST