Oracle Discoverer timestamp differences


	Applies To

	Product(s):	Exor Application Server / Oracle Discoverer
	Version(s):	11g
	Environment:	N/A
	Area:	N/A
	Subarea:	N/A
	Original Author:	Bentley Technical Support Group

Problem

Reports saved in Discoverer plus has time of 14:22, but when viewed in Discoverer Viewer it shows 13:22.

Solution

Suggestion from Oracle Support:
Discoverer Server uses the database time and timezone to show the last modified or creation time. Discoverer Viewer converts the timestamp to "local time" according to the local machine (middle tier) timezone.

Set the database time and middletier timezone to the desired time to see the same time in Discoverer Viewer as that in Discoverer Plus / Desktop.

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!