Re: Retrieving timezone value from database

What's the difference between the following:

Anyone can verify???

SQL > select tz_offset('Asia/Singapore') from dual ; ( available on 9i only )

SQL > select dbtimezone from dual ; ( available from 8i and 9i only)

Following are result returned from a 9i oracle database query. Seems both are querying for DBTIMEZONE but different result from ther queries

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

TZ_OFFS

+08:00

SQL> select dbtimezone from dual ;

DBTIME

+00:00

--
Posted via http://dbforums.com