Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: GMT/UTC from Oracle 8i

Re: GMT/UTC from Oracle 8i

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 01 Nov 2001 10:46:34 GMT
Message-ID: <3be127bd.5591823@news>


In a valiant and sublime effort,ahillman3 frowned, dipped a thumb in soot and doodled:

>I am trying to get the results from DBTIMEZONE to convert into something

Hehehe, this must be a sunspot high activity period or something...

>
>How do I subtract/add the timezon to SYSDATE?
>

select sysdate-(dbtimezone/24) from dual;

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Nov 01 2001 - 04:46:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US