Hi All,
I have recently found a problem that LOCALTIMESTAMP and CURRENT_TIMESTAMP as well are returning wrong values. These functions return time exactly one hour older than system time and than what is returned by SYSTIMESTAMP. SYSTIMESTAMP returns correct date.
I think that this can be caused by daylight saving time change. On March 27. there was a change to summer time, so the time has moved one hour ahead. I found out that affected sessions were started before March 27., so I believe that LOCALTIMESTAMP and CURRENT_TIMESTAMP still display winter time, while SYSTIMESTAMP was properly switched to winter time.
If I start new session (same way as all previous were started) then all timestamps display proper time.
Our DB version is:
SQL> select * from v$VERSION;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Did anybody observed the same issue?