Answers for "current setting postgres timezone"

postgres set timezone

SET TIME ZONE 'Europe/Moscow';

Posted by: Guest on November-16-2020

postgresql date at timezone

select updatedat AT TIME ZONE 'UTC';

Posted by: Guest on February-24-2021

current setting postgres timezone

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

Posted by: Guest on December-13-2021

Code answers related to "current setting postgres timezone"