The following bug has been logged online:
Bug reference: 2443
Logged by: nikolaus klepp
Email address: dr.klepp@gmx.at
PostgreSQL version: 8.0.3, 7.4.8
Operating system: suse linux 10.0
Description: 1 hour error at date calculation
Details:
i want to calculate the number of days in a month. when I do it this way:
select date_trunc('month', date_trunc('month', date('2006-3-1'))+interval
'1month')-date_trunc('month', date('2006-3-1'));
the result is: 30 days 23:00:00
that is obviously wrong.