Getting GMT Time in Oracle?

From: PoutineQ <poutineq_at_my-deja.com>
Date: Mon, 30 Oct 2000 17:53:03 GMT
Message-ID: <8tkchq$s8u$1@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 - 11:53:03 CST