How To Change The Time Zone In PostgreSQL

IT Support Forum Forums Databases PostgreSQL General Discussion How To Change The Time Zone In PostgreSQL

Tagged: 

Viewing 0 reply threads
  • Author
    Posts
    • #1899
      Webmaster
      Keymaster

      To change the time zone in PostgreSQL, run this SQL command against the database you want to change the time zone for:

      alter database databasename set timezone = ‘GMT’

      Obviously change GMT to the time zone that you want to use and the databasename to the name of the database you want to change the time zone for.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.