The following bug has been logged online:

Bug reference:      1749
Logged by:          Nick Johnson
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system:   FreeBSD
Description:        date_trunc('week', ...) is incorrect for some dates
Details: 

numa=# SELECT date_trunc('week', '2002-12-31'::date);
       date_trunc       
------------------------
 2001-12-31 00:00:00-05
(1 row)

Obviously this isn't the expected behaviour...

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to