On the last Sunday of October you may get “one more hour of sleep”, but also spend much more time debugging application code dealing with the time zones, daylight saving time shifts and datetime stuff in general. We’ll look at a few pitfalls you may encounter when working with datetime objects in PostgreSQL. We’ll discuss the difference between the TIMESTAMP WITH and WITHOUT TIMEZONE types and discover where the time zone information comes from. You’ll see that even if you do everything correctly, there may be some potential problem hidden somewhere and you’ll be unable to solve it by any computational means.
This talk contains 20% SQL and 80% history and politics.