Hi ,
What is the right approach for using AT TIME ZONE function?
Option 1: AT TIME ZONE 'IST'
Option 2: AT TIME ZONE 'Asia/Kolkata'
In the first option, I get +2:00:00 offset (when *timezone_abbrevations =
'Default'*) and for option 2 , +5:30 offset.
I can see multiple entries for IST in pg_t
Rajin Raj writes:
> Option 1: AT TIME ZONE 'IST'
> Option 2: AT TIME ZONE 'Asia/Kolkata'
> In the first option, I get +2:00:00 offset (when *timezone_abbrevations =
> 'Default'*) and for option 2 , +5:30 offset.
> I can see multiple entries for IST in pg_timezone_names with
> different utc_offs
Thanks for the clarification.
Is it advisable to modify the Default? Will it override when we apply a
patch or upgrade the DB?
What about creating a new file like below and update the postgres.conf with
the new name.
# New tz offset
@INCLUDE Default
@OVERRDIE
IST 19800
