Hooray for DST.
The UK switched to DST at 2am yesterday, and a scheduled job that monitors system activity started reporting a discrepancy between SYSDATE and the maximum time that any record was modified.
When I login to the database using either SQL*Plus or SQL Developer from my desktop I see that SYSDATE is one hour ahead of the host date/time, and it matches current_date whn the sessiontimezone is +01:00 ...
SQL> select sysdate,current_date,sessiontimezone from dual;
SYSDATE CURRENT_DATE
------------------- -------------------
SESSIONTIMEZONE
---------------------------------------------------------------------------
2011-03-28 09:44:21 2011-03-28 09:44:21
+01:00
I have never seen sysdate to be different to the host time like this, so I'm a bit baffled.
Does anyone have any ideas?