From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jayadevan M <maymala.jayadevan@gmail.com>
cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: Doubt on pg_timezone_names and pg_timezone_abbrevs
In-reply-to: <CAFS1N4go0PyXzR=krVN1EqdBx+T_Wv+P736KxDyZ8ZGuCfi8Rw@mail.gmail.com>
References: <CAFS1N4go0PyXzR=krVN1EqdBx+T_Wv+P736KxDyZ8ZGuCfi8Rw@mail.gmail.com>
Comments: In-reply-to Jayadevan M <maymala.jayadevan@gmail.com>
	message dated "Tue, 01 Apr 2025 09:08:50 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <278821.1743480394.1@sss.pgh.pa.us>
Date: Tue, 01 Apr 2025 00:06:34 -0400
Message-ID: <278822.1743480394@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/278822.1743480394%40sss.pgh.pa.us>
Precedence: bulk

Jayadevan M <maymala.jayadevan@gmail.com> writes:
> I used 'IST'  in a query like this - * (timestamp_hour) at time zone 'IST'
> time_ist *and did not get the expected output - timestamp in Indian
> Standard Time.

I think IST defaults to 'Israel Standard Time', a/k/a Asia/Jerusalem,
a/k/a UTC+2.  To get it to mean Indian Standard Time a/k/a Asia/Calcutta
you need

set timezone_abbreviations TO 'India';

(or more likely, adjust that in your installation's postgresql.conf).

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

			regards, tom lane