we observerd that the Oracle $$DATE$$ and SYSTEM Object property "CurrentDatetime" uses Oracle system variable SYSTEM.Current_datetime to retrieve the current system date/time value. I also see that SYSTEM.Current_datetime is NOT in Sync with Client/Server Time. Also please verify the results of the following query that was run in our environment where the issue appears.
SQL Statement which produced this data:
select sysdate ,
new_time(sysdate, 'MDT', 'EDT') LOCAL_TIME,
new_time(sysdate, 'MDT', 'EDT') - (substr(sessiontimezone,1,instr(sessiontimezone,':')-1)/24) CLIENT_TIME,
new_time(sysdate, 'MDT', 'MDT') - (substr(dbtimezone,1,instr(dbtimezone,':')-1)/24) DB_TIME
Based on the above results, does the value of DBTIMEZONE and SESSIONTIMEZONE need to in Sync. If so, how do we make the change to Sync the values. Also is that the root cause of the problem for SYSTEM.Current_DateTime to be in out of sync with the client/Server Time.
what SYSTEM.Current_datetime value depends on. Where do we need to set the value so the values are in Sync???