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

Sreedhar Barakam wrote:
>
> Can you get Timezone info. like EDT, EST etc. from oracle sys
> date/time functions?
>
> There are tonnes of functions that return all kinds of
> information about date/time except the above in Oracle
> documentation. Can anyone say if it is possible to
> get this information. Is there an additional product
> that will let you hook into os function calls(date on
> OS does return this 3-letter code for timezone.)?
>
> thanks,
> please email: sbarakam_at_ingr.com
YES, you can user NEW_TIME function to get time zone info

NEW_TIME( date, zone1, zone2)
returns the date and time in time 'zone2' when date and time in time zone 'zone1' and 'date'. The arguments zone1 and zone2 can be any of the following strings.

AST or ADT -- ATLANTIC
BST or BDT -- BERING STANDARD
CST or CDT -- CENTRAL
GMT        -- GREENWICH MEAN TIME
HST or HDT -- ALASKA
MST or MDT -- MOUNTAIN
NST        -- NEWFOUNDLAND
PST or PDT -- PACIFIC
YST or YDT --YUKON

Hope this helps...

-- 
    AMARENDRA B NETTEM
    ORACLE CONSULTANT
    WHITTMAN-HART CORPORATION, CHICAGO
    (http://www.iit.edu/~nettama)