Webinar: Date/Timestamp types in PostgreSQL

Wednesday, April 22, 2020 at 4pm UTC

PostgreSQL provides powerful, native support for handling Date/Timestamp data types. Andrew Dunstan will dive into the various data types you can use in both structured and unstructured formats. The following key topics will be 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


Andrew Dunstan

Andrew Dunstan

Senior Developer & PostgreSQL Committer

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.

Know someone who would be interested in attending? Share the webinar with them!