Hello Experts,
BI Publisher==>10.1.3.4.1 (With Latest cumulative patches)
Database version==>10.2.0.4 or 11.1.0.7
Both Database and BIP are running on same host whose time is synchronized using ntp. Currently they are running in Day Light Saving timezone.
Query==>select dbtimezone, TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW", sessiontimezone,CURRENT_TIMESTAMP from dual
OUTPUT FROM BIP
--------------------------
- <ROWSET>
- <ROW>
<DBTIMEZONE>+00:00</DBTIMEZONE>
<NOW>01-17-2011 12:05:43</NOW>
<SESSIONTIMEZONE>+09:00</SESSIONTIMEZONE>
<CURRENT_TIMESTAMP>2011-1-17 10.5.43.760751000 9:0</CURRENT_TIMESTAMP>
</ROW>
</ROWSET>
OUTPUT FROM DB
--------------------------------
DBTIME NOW
------ -------------------
SESSIONTIMEZONE
---------------------------------------------------------------------------
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
+00:00 01-17-2011 11:51:20
+11:00
17-JAN-11 11.51.20.198031 AM +11:00
OUTPUT FROM SQL DEVELOPER
----------------------------------------------------
dbtimezone now sessiontimezone currenttimestamp
+00:00 01-17-2011 11:54:56