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