SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between dbtimezone and system timezone?

424775Feb 28 2007 — edited Feb 28 2007

Hi All,

What is the difference between the timezone, we are getting from dbtimezone function, and the timezone shown by the systimestamp? As in the below query dbtimezone is +00:00 but systimestamp is showing +05:30.
At the time of installing my 10g database in my machine (winxp) it was being asked to select the time zone then and I had select 'GM +05:30 New Delhi'.

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL> select dbtimezone, systimestamp from dual;

DBTIME SYSTIMESTAMP
------ ---------------------------------------------------------------------------
+00:00 28-FEB-07 02.00.12.304000 PM +05:30

Can someone guide me on that.

Thanks
Ravi

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2007

Added on Feb 28 2007

2 comments

949 views