• Facebook
  • X
0 Items
Paul Myrick
  • Blog
  • Website Portfolio
  • Contact Paul
  • Artwork
Select Page

PostgreSQL Database Time Zones and Timestamp Time Zone Conversion in SQL

by Paul Myrick | Aug 12, 2023 | Database, PostgreSQL

PostgreSQL stores timestamps with time zones in Greenwich Mean Time (GMT); however, the database can be configured to return timestamps in a different time zone. To set the default time zone for a database, use the ALTER DATABASE command. For example, the following...

Paul’s Other Websites

  • The Parodies
  • Paul Myrick Photography
  • Recipe Renaissance
  • Social Media Recipe Fails
  • Imitation of Mink
  • The Outside Adventure of Liza & Louie

Favorite Websites

  • Robin Davis Photography
  • Cortona Center of Photography
  • The Third Eye
  • Faustina Noire
  • Allen Matthews Photography
  • Damara Davidson Photography
  • Thomas Gruber
  • Beads on Belrose
  • The way it seems … it not always the way it is.