Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GMT/UTC from Oracle 8i
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