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

Home -> Community -> Usenet -> c.d.o.misc -> Retrieving timezone value from database

Retrieving timezone value from database

From: eugeneteo <member33264_at_dbforums.com>
Date: Mon, 20 Oct 2003 10:34:11 -0400
Message-ID: <3501341.1066660451@dbforums.com> 






Hi all,





how can I retrieve the timezone value from database (Oracle 7i)?





from oracle 8i,9i we can use :





select dbtimezone from dual ;





As for 7i, how can I find out this info. Or timezone is not
supported in 7i?



--
Posted via http://dbforums.com


Received on Mon Oct 20 2003 - 09:34:11 CDT












Original text of this message













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