Time difference in Siebel Application

Oct 4, 2013 8:17AM

Hello All,

1.Siebel Application Server is running 8.1.1.7 version.

2.Database Time zone is :-

SQL> select dbtimezone,SYSTIMESTAMP from dual;

DBTIMEZONE----------

SYSTIMESTAMP-----------------------------------------------

US/Central 04-OCT-13 11.56.38.875381 AM -05:00

3.Siebel Application Server's System Preferences' Default Time Zone has following value :-

(GMT-05:00) Eastern Time (US & Canada)

4.Siebel Application Server's System Preference's UTC enabled is set to TRUE.

5.I created an Opportunity Record in Siebel Application and see last updated date as

Last Updated Source: User

Last Updated On: 10/4/2013 12:38:19 PM

6.While querying same record from backend at database level :-

SQL> select TO_CHAR(LAST_UPD, 'DD-MON-YYYY HH24:MI:SS') from siebel.s_opty where row_id='1-1WHLG2'

Siebel Business Process & Functionality (MOSC)