Search Postgresql Archives

Re: timestamp skew during 7.4 -> 8.2 upgrade

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Aug 09, 2007 at 05:27:55PM +0000, Louis-David Mitterrand wrote:
> Hi,
> 
> After our 7.4 to 8.2 upgrade using debian tools, we realized that some 
> of our timestamps with tz had shifted:
> 
> For example '2007-04-01 00:00:00+02' became '2007-03-31 23:00:00+01' 
> which is on a different month. Some of our applications were severely 
> disturbed by that.

Youv've got the answer to your question, but I wonder if your app
really wanted just a "date" rather than a whole timestamp, which avoids
the issue entirely.

As for the difference between timestamp with/without timezone, it
depends on your usage. If the data represents an actual instant in
time, that you want to have rotated to the local time of the person
viewing, you need "with". If the data represents what the clock on the
wall said at the moment it happened and you don't want it rotated, no
matter what, you need "without".

Hope this helps,
-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux