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
but which i insert into the databases is showing empty column.
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