I'm seeing some odd behavior (to me) around a timestamp without timezone
column. Was hoping someone could shed some light on this for me. I
insert current_timestamp into the column. When I select the value it is
the expected UTC time. When I select the value with "AT TIME ZONE EDT"
I expected it to return in eastern time which is UTC - 4, but is
returning as UTC + 4. Is AT TIME ZONE incompatable with this data type?

Postgres 8.1.11
OS time is UTC
Postgres timezome is UTC

I did the below example at 12:58 eastern time. UTC time was 16:58.

I have a table with a column timestamp without timezone.

matthew/[local] hdap=# \d billing.stefan_test;
Table "billing.stefan_test"
Column | Type | Modifiers
--------+-----------------------------+-----------
dt | timestamp without time zone |

I insert a record.
INSERT INTO billing.stefan_test(dt)
VALUES (CURRENT_TIMESTAMP);

matthew/[local] hdap=# select dt, dt AT TIME ZONE 'EDT' from
billing.stefan_test;
dt | timezone
----------------------------+-------------------------------
2008-10-17 16:58:51.240091 | 2008-10-17 20:58:51.240091+00 <<< Was
expecting 12:58:51
(1 row)

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedOct 17, '08 at 5:44p
activeOct 17, '08 at 6:37p
posts3
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Stefan Murphy: 2 posts Tom Lane: 1 post

People

Translate

site design / logo © 2022 Grokbase