BI Publisher (MOSC)

MOSC Banner

sessiontimezone is wrong in Bi Publisher 10.1.3.4.1

edited Aug 22, 2024 3:56PM in BI Publisher (MOSC) 17 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center