Session level timezone in Postgres

You can set timezone at session level in Postgres using SET. It allows to override the server-level timezone for a specific session.

SET timezone = 'US/Pacific';

You can use the SELECT statement to verify the current timezone by executing:

SELECT current_setting('timezone');
| current_setting |
| US/Pacific      |

Stay up to date

Get notified when I publish something new, and unsubscribe at any time.