Re: Time zone "GST" not recognized.

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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com