Jayadevan M <maymala.jayade...@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
