Re: Getting GMT Time in Oracle?

You might try the new_time function:

new_time(date, 'this zone', 'output zone')

select to_char(new_time(sysdate,'CST','GMT'),'MON DD YYYY HH24MI') from dual;

PoutineQ wrote in message <8tkchq$s8u$1_at_nnrp1.deja.com>...
>Hi,
>
>This is probably a simple question, but I haven't figured it out
>yet. I would like to get the current time in GMT from Oracle (8,
>HP-UX).
>
>In SYBASE, I was able to do "select getdate()", and I am trying to
>port that code to Oracle.
>
>
>The 'sysdate' function returns the local time. But, it does not
>seem to return the time zone. The NEW_TIME() function also seems
>to not be of much help, because I need to have the current
>time zone, plus I would need to know if I'm in DST or not.
>
>Thanks,
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Oct 30 2000 - 15:09:27 CST