4 ms·
Another thing that will cause 31 December 1969, regardless of timezones, is the use of -1 as a sentinel value, because taken as a literal time value that's one
by tialaramex 3y ago
Another thing that will cause 31 December 1969, regardless of timezones, is the use of -1 as a sentinel value, because taken as a literal time value that's one second before the start of the epoch, and thus it's also on 31st December 1969.
But if you checked the time and it's some hours off, rather than a second or two, then yes, that's timezones.
- netsharc 3y agoWell, isn't the number always interpreted as seconds (or milliseconds) at UTC? In theory if the system's timezone is set to e.g. +10:00, -1 (seconds) is 1970-01-01 09:59:59 local.
- erik_seaberg 3y agoBe careful out there; back in 2006 I learned the hard way that FROM_UNIXTIME(-1) would instantly crash the MySQL build we had in prod.