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: ahillman3 <Allen_Hillman_at_technologist.com>
Date: 1 Nov 2001 13:11:29 -0500
Message-ID: <3be19051$1@usenetgateway.com> 





select sysdate-(dbtimezone/24) from dual;



This returns: ORA-00907: missing right parenthisis



What am I doing wrong?



Is there a configuration problem?



Thanks for the continued assistance.



Allen H.




--
Posted via dBforums
http://dbforums.com


Received on Thu Nov 01 2001 - 12:11:29 CST












Original text of this message













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