From: mark_postgres_user <mark.ikemoto@fireeye.com>
To: pgsql-admin@postgresql.org
Subject: Re: displaying UTC time in local time
Date: Tue, 29 Oct 2013 07:05:58 -0700 (PDT)
Message-ID: <1383055558685-5776257.post@n5.nabble.com> (raw)
In-Reply-To: <13452.1383001151@sss.pgh.pa.us>
References: <1382997116262-5776169.post@n5.nabble.com>
<13452.1383001151@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mark.ikemoto@fireeye.com
Subject: Re: displaying UTC time in local time
In-Reply-To: <1383055558685-5776257.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox