On Tue, Apr 1, 2025 at 9:28 AM David G. Johnston
wrote:
> On Mon, Mar 31, 2025 at 8:39 PM Jayadevan M
> wrote:
>
>> Hello PG members,
>> 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 T
Jayadevan M 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 Stan
On Mon, Mar 31, 2025 at 8:39 PM Jayadevan M
wrote:
> Hello PG members,
> 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. So I queried the 2 views that provide timezone info and did
>
