"Nicholas Vinen" <[EMAIL PROTECTED]> writes:
> This is definitely not right:
> rt3=# SELECT date_trunc('week', timestamp with time zone '2005-01-02
> 00:00:00-7');
>date_trunc
>
> 2006-01-02 00:00:00-08
> (1 row)
Already fixed in 8.0.2.
The following bug has been logged online:
Bug reference: 1649
Logged by: Nicholas Vinen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Gentoo Linux
Description:Date calculation year off-by-one error
Details:
This is definitely not right