We're hosting this meetup on short notice, but it's been awhile and we had a great topic and speaker come up, so why not?
PostgreSQL has robust date and time support, so robust that there are entire talks on it...like this one! Join Erik Larsen as he discusses his explorations with PostgreSQL dates and times and how you best learn PostgreSQL dates and times in your applications!
When I was a new addition to the Codesmith team, my first task was to ensure that events created by our admins were stored at the correct time in our Postgres database. As it stood, once events were retrieved from the database, they were several hours off. Seemed like a pretty easy task -- just fix the time offset and be done with it. But as I started to dig deeper into the Postgres date-time docs and others' timezone implementations, my very conception of timezones themselves was challenged. Join me as we explore all of the ways that Postgres deals with dates, times, and timezones, and how best to implement date-times in your own database.