Answers for "postgres set timezone for query"

postgres set timezone

SET TIME ZONE 'Europe/Moscow';

Posted by: Guest on November-16-2020

current setting postgres timezone

SELECT * FROM pg_timezone_names WHERE name = current_setting('TIMEZONE');

Posted by: Guest on December-13-2021

storing timezones in postgres

select name from pg_timezone_names where name not like 'posix%' and name not ilike 'system%' order by name;

Posted by: Guest on February-24-2021

Code answers related to "postgres set timezone for query"