Timezone changes

Hi:

    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?

    Thanks!
- Rolf. Received on Wed Jan 24 2001 - 19:41:43 CST