Re: Retrieving timezone value from database

eugeneteo wrote:

SQL> select tz_offset('Asia/Singapore') from dual ;

TZ_OFFSET('ASIA/SINGA

SQL> select dbtimezone from dual ;

DBTIMEZONE

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

And no - timezones are not supported in 7

-- 
Regards, Frank van Bortel