Mission Critical Databases

Webinar: Date/Timestamp types in PostgreSQL

This webinar was held on 22 April 2020.

PostgreSQL provides powerful, native support for handling Date/Timestamp data types. Andrew Dunstan hosted this webinar and dived into the various data types you can use in both structured and unstructured formats. The following key topics were discussed during the webinar:

  • Introduction to four basic date/timestamp types in PostgreSQL
  • Precision and storage
  • Settings that affect input and output
  • Formatting, functions, and time zones
  • Operators and date/time arithmetic
  • Extracting fields from date/time data
  • Truncating date and time data
  • Functions for current date and time
  • Indexing date and time types
  • Date and time data in JSON
  • Date and time Range types
Speaker: Andrew Dunstan | Senior Developer & PostgreSQL Committer


DateTimestamp types in PostgreSQL by Andrew Dunstan - Hubspot

Andrew Dunstan has been involved with PostgreSQL since his first contribution in 2003. In 2004 he created the PostgreSQL Build Farm system, which he has maintained ever since. In 2005 he was made a core committer of the PostgreSQL project. Andrew has contributed many features to PostgreSQL including dollar quoting, CSV import and export, PL/Perl enhancements, CSV logging, parallel pg_restore and enum extensibility. He is also one of the contributors to work on the Windows port feature