From: | mark_postgres_user <mark(dot)ikemoto(at)fireeye(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: displaying UTC time in local time |
Date: | 2013-10-29 14:05:58 |
Message-ID: | 1383055558685-5776257.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> Those statements apply to values of type timestamp WITH timezone.
> A timestamp WITHOUT timezone is just what-you-see-is-what-you-get.
Thanks for this clarification.
To recap: So, because my timestamps are defined as timestamp without
timezone data type and are stored in UTC, when I display them in their
default form they'll be displayed in UTC. I can use AT TIME ZONE to convert
the displayed time to any timezone including my local timezone.
So why is it that I can get the displayed time to be local only if I use "AT
TIMEZONE 'UTC'" ? Anything else will either be ignored or display UTC.
Is there a more intuitive way of getting these timestamps displayed in local
time?
P.S. Someone else owns the database I'm using so I can't change the
timestamps to be timestamp with timezone.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/displaying-UTC-time-in-local-time-tp5776169p5776257.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2013-10-29 14:21:02 | Re: displaying UTC time in local time |
Previous Message | Paul Warren | 2013-10-29 13:08:36 | Re: pg_dump being killed by oom killer |