[BUGS] BUG #1749: date_trunc('week', ...) is incorrect for some dates -
07-04-2005
, 08:15 AM
The following bug has been logged online:
Bug reference: 1749
Logged by: Nick Johnson
Email address: arachnid (AT) notdot (DOT) net
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 majordomo (AT) postgresql (DOT) org) |