Postgres Pro
Downloads
Home   >   mailing lists

Timezone conversion - Mailing list pgsql-sql

From Jeff Boes
Subject Timezone conversion
Date
Msg-id usfo4vs8tq35e486ha9pbc6gcu921d3uhn@4ax.com
Whole thread Raw
Responses Re: Timezone conversion  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Tree view 
Is there a straightforward way to change the display of a time to another
timezone?  For example, my server's environment is EST (-0500); I want to
convert timestamps for display in PST (-0800).  What I've been doing is to use a
Pl/Pgsql function to subtract the current timezone-offset and add in the desired
one.  Is there a way to do it without arithmetic?

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: rownum
Next
From: Josh Berkus
Date:
Subject: Re: Drop temporary table only if it exists