Re: Can you get Timezone info. like EDT, EST etc. from oracle sys date/time functions?

AMARENDRA B NETTEM wrote:
>
> Sreedhar Barakam wrote:
> >
> > Can you get Timezone info. like EDT, EST etc. from oracle sys
> > date/time functions?[snip]
> YES, you can user NEW_TIME function to get time zone info[snip]

Though useful, NEW_TIME only adds or subtracts an offset, it isn't smart enough to do "real" timezone conversion i.e to keep track of when DST went into/out of effect and do "the right thing" with the time value the way localtime() does on a Unix system. (Or at least the way localtime() does for GMT/UTC/Z -> local).

Anyone seen something for Oracle that does? (and doesn't require a daemon running on the end of a dbms_pipe to do the deed).

-- 
Bill Meahan  wmeahan_at_ford.com
Ford Motor Company -- End User Support - North America
Not an official statement of Ford Motor Company or anyone else
except the author.