Re: GMT/UTC from Oracle 8i

I am trying to get the results from DBTIMEZONE to convert into something I can add to SYSDATE to get the correct offset.

e.g. SELECT SYSDATE + DBTIMEZONE FROM DUAL (Doesn't work)

I've tried using to_char to convert the DBTIMEZONE, but it keeps complaining about missing right parenthesis.

---

How do I subtract/add the timezon to SYSDATE?

Allen H.

--

Posted via dBforums
http://dbforums.com Received on Wed Oct 31 2001 - 14:12:01 CST