We got into the same issue then we used Java(java Stored Procedure) to
accomplish the same.


-----Original Message-----
From: Darren S. Eyers [mailto:[Email Address Removed] Sunday, November 30, 2003 5:47 PM
To: LazyDBA.com Discussion
Subject: DB Instance Data


Hi All,
Any idea how to get the DB Instance date with the timezone?

The query below give me the database time zone as a time zone offset, but
can I get the region name like GMT, EST, MET etc.
select dbtimezone
from dual;

Cheers,
Darren



--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page