Re: Time zone "GST" not recognized. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Time zone "GST" not recognized.
Date
Msg-id 2e64be1d-46e2-bfa4-bf6a-30455e237197@aklaver.com
Whole thread Raw
In response to Re: Time zone "GST" not recognized.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Time zone "GST" not recognized.
List pgsql-general
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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Time zone "GST" not recognized.
Next
From: Matt Zagrabelny
Date:
Subject: continuation character for meta commands in psql