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: 

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 5 months ago.

  • 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.

You must be logged in to reply to this topic.