Alessandro Gagliardi <alessandro@xxxxxxxx> wrote: > All of our servers run in UTC specifically to avoid this sort of > problem. It's kind of annoying actually, because we're a San > Francisco company and so whenever I have to do daily analytics, I > have to shift everything to Pacific. But in this case it's handy. If that's working for you, you might just want to leave it alone; but just so you know: If you declare the column as TIMESTAMP WITH TIME ZONE, that it stores the timestamp as UTC regardless of what your server's definition of time zone is. (It doesn't actually store the time zone -- it just normalizes the time into UTC for storage.) On retrieval it shows that UTC moment in the local timezone. So, all that work you're doing to switch the time zone info around would be pretty automatic if you used the other type. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
