From: | Shridhar Daithankar <ghodechhap(at)ghodechhap(dot)net> |
---|---|
To: | pg-general <pgsql-general(at)postgresql(dot)org> |
Subject: | timestamp with timezone and time zone name |
Date: | 2012-08-07 03:53:29 |
Message-ID: | 3206980.ZoNXykaEeD@bheem |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I am wondering, why following two values result in a shift by 3.5 hours. I
would expect them to be identical.
I understand that canonical time zone names could be ambiguous at times but I
think IST is not one of them.
Any explanation?
---------------
test=# select '2012-08-07 05:24:56.758891+05:30'::timestamptz;
timestamptz
----------------------------------
2012-08-07 05:24:56.758891+05:30
(1 row)
test=# select '2012-08-07 05:24:56.758891 IST'::timestamptz;
timestamptz
----------------------------------
2012-08-07 08:54:56.758891+05:30
(1 row)
shridhar(at)bheem ~$ psql test
psql (9.1.4)
Type "help" for help.
test=# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 9.1.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.7.0
20120505 (prerelease), 64-bit
(1 row)
---------------
TIA.
--
Regards
Shridhar
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-08-07 04:21:04 | Re: timestamp with timezone and time zone name |
Previous Message | Shridhar Daithankar | 2012-08-07 03:51:05 | How does connect privilege works? |