Mike Christensen wrote:
> Awesome! One more followup question..
>
> If I modify an existing table from timestamp to timestamptz, will it use the
> current system timezone? If so, how can I modify all the rows to convert to
> UTC time (basically add 8 hrs to everything)..
I think you just cast i
Awesome! One more followup question..
If I modify an existing table from timestamp to timestamptz, will it use the
current system timezone? If so, how can I modify all the rows to convert to
UTC time (basically add 8 hrs to everything)..
On Mon, Jun 15, 2009 at 6:52 PM, Bruce Momjian wrote:
>
Mike Christensen wrote:
> Hi all -
>
> I'm considering changing all my "timestamp" columns to "timestamp with
> timezone" columns instead. The reason is I want to use UTC time for
> everything in the DB and on the web server, and only ever convert to local
> time on the client itself. I could us
