postgres default timezone

by

The time zone is a session parameter. So, you can change the timezone for the current session.

See the doc.

set timezone TO 'GMT';

Or, more closely following the SQL standard, use the SET TIME ZONE command. Notice two words for “TIME ZONE” where the code above uses a single word “timezone”.

SET TIME ZONE 'UTC';

The doc explains the difference:

SET TIME ZONE extends syntax defined in the SQL standard. The standard allows only numeric time zone offsets while PostgreSQL allows more flexible time-zone specifications. All other SET features are PostgreSQL extensions.

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. PostgreSQL LIKE query performance variations
  3. Calculating and saving space in PostgreSQL
  4. Generating a UUID in Postgres for Insert statement?
  5. Why does PostgreSQL perform sequential scan on indexed column?
  6. PostgreSQL naming conventions
  7. How to set value of composite variable field using dynamic SQL
  8. In-order sequence generation
  9. Does not using NULL in PostgreSQL still use a NULL bitmap in the header?
  10. How to generate the “create table” sql statement for an existing table in postgreSQL
  11. Postgres password authentication fails
  12. Generate series of dates – using date type as input
  13. Copy a few of the columns of a csv file into a table
  14. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  15. How do you create a random string that’s suitable for a session ID in PostgreSQL?
  16. Joining Results from Two Separate Databases
  17. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  18. Update timestamp when row is updated in PostgreSQL
  19. Postgresql query array of objects in JSONB field
  20. Multicolumn index on 3 fields with heterogenous data types
  21. Select from a table variable
  22. Heroku database restore issue
  23. user postgres launches process that takes all CPUs 100% usage
  24. PostgreSQL disable more output
  25. PostgreSQL array_agg order
  26. Postgres table column name restrictions?
  27. How do I get min, median and max from my query in postgresql?
  28. PostgreSQL jsonb, `?` and JDBC
  29. Syntax error at end of input in PostgreSQL
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment