On 1/24/20 9:57 AM, nikhil raj wrote:
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
What is the type definition for the database column you are entering the
data in?
Are you entering these by hand?
What happens if you use Asia/Dubai or Asia/Muscat as the time zone?
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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
