[SQL] Timestamp in PG - 7.1 & 7.2

[Anagha Joshi]

Hi, I�ve observed this: Here is output from PostgreSQL 7.1.2:   trapdb=# select cast(datetime(1057637700) as timestamp);          ?column?          ---------------------------  2003-07-08 09:45:00+05:30 (1 row)   Here is output from PostgreSQL 7.2.4:   trapdb=# select cast(datetime(1057637700) as timestamp);          timestamp ---------------------------  2003-07-07 22:45:00+05:30 (1 row)   I�ve migrated from PG - 7.1.2 to 7.2.4.   My timezone is set as �IST� in both cases. Is this any version problem or� I�m missing any envirnonment setting?   Help is appreciated�.   Thanks, Anagha