Timestamp in PG - 7.1 & 7.2

From: "Anagha Joshi" <ajoshi(at)nulinkinc(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Timestamp in PG - 7.1 & 7.2
Date: 2003-08-05 10:21:52
Message-ID: FF851C7EEB75954F9BCFB5CA117AB1EC61A555@delta.nulinkinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Knut P. Lehre 2003-08-05 11:13:00 Re: length of recordset read through a cursor
Previous Message Joe Conway 2003-08-04 20:29:56 Re: [SQL] EXTERNAL storage and substring on long strings