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.kla...@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.kla...@aklaver.com >
