Answers for "postgres set timezone"

2

postgres set timezone

SET TIME ZONE 'Europe/Moscow';
Posted by: Guest on November-16-2020
0

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
0

postgresql date at timezone

select updatedat AT TIME ZONE 'UTC';
Posted by: Guest on February-24-2021

Browse Popular Code Answers by Language