Breaking News: Grepper is joining You.com. Read the official announcement!

storing timezones in postgres

Better Bee answered on November 16, 2020 Popularity 10/10 Helpfulness 3/10

answer storing timezones in postgres

related current setting postgres timezone

storing timezones in postgres

Comment

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

Popularity 10/10 Helpfulness 3/10 Language sql

Source: www.magistratehq.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Feb 24 2021

Better Bee

0 Answers Avg Quality 2/10

Closely Related Answers

current setting postgres timezone

Comment

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

Popularity 10/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: setting

Link to this answer
Share Copy Link

Contributed on Dec 13 2021

Kirk-Patrick Brown

0 Answers Avg Quality 2/10

postgres set timezone

Comment

SET TIME ZONE 'Europe/Moscow';

Popularity 10/10 Helpfulness 5/10 Language whatever

Source: Grepper

Tags: set

Link to this answer
Share Copy Link

Contributed on Nov 16 2020

Evolcon

0 Answers Avg Quality 2/10

timestamp with timezone postgres

Comment

foo=> SET TIMEZONE TO 'Japan';
SET
foo=> SELECT '2011-01-01 00:00:00'::TIMESTAMP;
      timestamp      
---------------------
 2011-01-01 00:00:00
(1 row)

foo=> SELECT '2011-01-01 00:00:00'::TIMESTAMP WITH TIME ZONE;
      timestamptz       
------------------------
 2011-01-01 00:00:00+09
(1 row)

foo=> SELECT '2011-01-01 00:00:00+03'::TIMESTAMP;
      timestamp      
---------------------
 2011-01-01 00:00:00
(1 row)

foo=> SELECT '2011-01-01 00:00:00+03'::TIMESTAMP WITH TIME ZONE;
      timestamptz       
------------------------
 2011-01-01 06:00:00+09
(1 row)

foo=> SET TIMEZONE TO 'Australia/Melbourne';
SET
foo=> SELECT '2011-01-01 00:00:00'::TIMESTAMP;
      timestamp      
---------------------
 2011-01-01 00:00:00
(1 row)

foo=> SELECT '2011-01-01 00:00:00'::TIMESTAMP WITH TIME ZONE;
      timestamptz       
------------------------
 2011-01-01 00:00:00+11
(1 row)

foo=> SELECT '2011-01-01 00:00:00+03'::TIMESTAMP;
      timestamp      
---------------------
 2011-01-01 00:00:00
(1 row)

foo=> SELECT '2011-01-01 00:00:00+03'::TIMESTAMP WITH TIME ZONE;
      timestamptz       
------------------------
 2011-01-01 08:00:00+11
(1 row)

Popularity 10/10 Helpfulness 5/10 Language whatever

Source: stackoverflow.com

Tags: timestamp-with-timezone timestamp-with-t

Link to this answer
Share Copy Link

Contributed on Nov 05 2021

Nutty Nightingale

0 Answers Avg Quality 2/10

storing timezones in postgres

Contents

More Related Answers

storing timezones in postgres

Closely Related Answers

current setting postgres timezone

postgres set timezone

timestamp with timezone postgres

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.