Hi all, I think there is a bug in the PostgreSQL date system: Try computing (replace XXXX with some differents years): 'XXXX-10-01'::datetime + '1 month'::interval Depending on the year, you can get 'XXXX-11-01' as expected or 'XXXX-10-31' which is bug. Guillaume Perréal - Stagiaire MIAG Cemagref (URH), Lyon, France Tél: (+33) 4.72.20.87.64
- Re: [BUGS] A date bug: number of day of October Guillaume Perréal
- Re: [BUGS] A date bug: number of day of October Peter Eisentraut
- Re: [BUGS] A date bug: number of day of October Tom Lane
- Re: [BUGS] A date bug: number of day of October Guillaume Perréal