Thread: Time zone "GST" not recognized.

nikhil raj <nikhilraj474@gmail.com> writes:
> 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.

There is no such time zone abbreviation according to the IANA
time zone database [1], which is what we rely on.

            regards, tom lane

[1] http://www.iana.org/time-zones

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

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

nikhil raj <nikhilraj474@gmail.com> writes:
> 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.

You could set up a private timezone abbreviation configuration.

https://www.postgresql.org/docs/current/datetime-config-files.html

            regards, tom lane

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@aklaver.com <mailto:adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com