Re: Time zone "GST" not recognized.

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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@xxxxxxxxxxx