Re: find out timezone for SYSDATE?

Dear Mark,

If you just want to do date conversion, you can try this

for example:

SELECT NEW_TIME(sysdate,'EST','GMT') from dual;

to convert Eastern Standard Time to GMT, or

SELECT NEW_TIME(sysdate,'EDT','GMT') from dual;

to convert Eastern Daylight Time to GMT.

I found this at the web site of
http://www.orafans.com/bbs/rdbmssql/bbs.htm . If the above SQL are not what you want, you may post you question in the above site.

Chadwick Leung.

Mark W Modrall ¼g¹D¡G

> Hi...
>
> is there any way to find out the timezone that SYSDATE
> is in? i called oracle support about this, but they're worse
> than trained monkeys... I don't see how any of the date conversion
> routines would be at all useful if you can't find out what timezone
> the system is in, but i couldn't find any way to do it...
>
> thanks
> -mark
Received on Wed Apr 05 2000 - 15:00:44 CDT