Storing dates and times in PostgreSQL, MySQL and JSON: timestamptz, DATETIME, Jackson and the traps
Timestamps vs datetimes, PostgreSQL timestamptz vs timestamp, MySQL TIMESTAMP vs DATETIME (the 2038 limit, session conversion), rounded fractional seconds, why future appointments need a zone id, JDBC/Hibernate/Connector/J, and JSON traps: Jackson, ISO 8601, epoch numbers and JavaScript Date.