Time zone "GST" not recognized.

nikhil raj <nikhilraj474@gmail.com> writes:

Required help with the time zone. i am getting error on the GST time line.
is tht a bug or postgres doesn't support the GST time zone.

There is no such time zone abbreviation according to the IANA
time zone database [1]http://www.iana.org/time-zones, which is what we rely on.

regards, tom lane

[1]: http://www.iana.org/time-zones

On 1/24/20 8:59 AM, nikhil raj wrote:

Hi ALL,

Required help with the time zone. i am getting error on the GST time
line. is tht a bug or postgres doesn't support the GST time zone.

select CURRENT_TIMESTAMP AT TIME ZONE 'GST'
ERROR: time zone "GST" not recognized SQL state: 22023

Try GMT:

test_(postgres)# select CURRENT_TIMESTAMP AT TIME ZONE 'GMT';
timezone
----------------------------
2020-01-24 17:17:52.754861

For list of recognized abbreviations:

https://www.postgresql.org/docs/11/view-pg-timezone-abbrevs.html

Postgres -:11.2
Ubuntu:-18.04

--
Adrian Klaver
adrian.klaver@aklaver.com

On 1/24/20 9:19 AM, Adrian Klaver wrote:

On 1/24/20 8:59 AM, nikhil raj wrote:

Hi ALL,

Required help with the time zone. i am getting error on the GST time
line. is tht a bug or postgres doesn't support the GST time zone.

select CURRENT_TIMESTAMP AT TIME ZONE 'GST'
ERROR: time zone "GST" not recognized SQL state: 22023

Try GMT:

test_(postgres)# select CURRENT_TIMESTAMP AT TIME ZONE 'GMT';
          timezone
----------------------------
 2020-01-24 17:17:52.754861

Aah, is this what you are looking for?:

https://24timezones.com/time-zone/gst

It seems to be an alias for UTC+04, though not recognized by IANA. That
would be:

Asia/Dubai or Asia/Muscat

Unless you are talking about:

https://24timezones.com/time-zone/gst_georgia

For list of recognized abbreviations:

https://www.postgresql.org/docs/11/view-pg-timezone-abbrevs.html

Postgres -:11.2
Ubuntu:-18.04

--
Adrian Klaver
adrian.klaver@aklaver.com

Hi Adrian,

Thanks for the quick response.

Please can you help me over here So Postgres is not supporting GST ( Gulf
Standard Time) time zone . As if we have a entries of few things with
timestamp with time zone from application end.

example :- In 2 column we are entering these details but when client from
GST time zone i am getting 21:41:39 GST

[image: image.png]

but which i insert into the databases is showing empty column.

On Fri, Jan 24, 2020 at 11:09 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

nikhil raj <nikhilraj474@gmail.com> writes:

Please can you help me over here So Postgres is not supporting GST ( Gulf
Standard Time) time zone . As if we have a entries of few things with
timestamp with time zone from application end.

You could set up a private timezone abbreviation configuration.

https://www.postgresql.org/docs/current/datetime-config-files.html

regards, tom lane

On 1/24/20 9:57 AM, nikhil raj wrote:

Hi Adrian,

Thanks for the quick response.

Please can you help me over here So Postgres is not supporting GST (
Gulf Standard Time) time zone .  As if we have a entries of few things
with timestamp with time zone  from application end.

example :- In 2 column we are entering these details but when client
from GST time zone i am getting 21:41:39 GST

What is the type definition for the database column you are entering the
data in?

Are you entering these by hand?

What happens if you use Asia/Dubai or Asia/Muscat as the time zone?

image.png

but which i insert into the databases is showing empty column.

On Fri, Jan 24, 2020 at 11:09 PM Adrian Klaver
<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:

On 1/24/20 9:19 AM, Adrian Klaver wrote:

On 1/24/20 8:59 AM, nikhil raj wrote:

Hi ALL,

Required help with the time zone. i am getting error on the GST

time

line. is tht a bug or postgres doesn't support the GST time zone.

select CURRENT_TIMESTAMP AT TIME ZONE 'GST'
ERROR: time zone "GST" not recognized SQL state: 22023

Try GMT:

test_(postgres)# select CURRENT_TIMESTAMP AT TIME ZONE 'GMT';
            timezone
----------------------------
   2020-01-24 17:17:52.754861

Aah, is this what you are looking for?:

https://24timezones.com/time-zone/gst

It seems to be an alias for UTC+04, though not recognized by IANA. That
would be:

Asia/Dubai or Asia/Muscat

Unless you are talking about:

https://24timezones.com/time-zone/gst_georgia

For list of recognized abbreviations:

https://www.postgresql.org/docs/11/view-pg-timezone-abbrevs.html

Postgres -:11.2
Ubuntu:-18.04

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com