ed to seconds).
> But representing days as seconds breaks at DST boundaries.
>
> regards, tom lane
Thanks you all,
As I just use this code to get the number of seconds in a month (and don't care
anyway of the timezone), I think I could use this:
select date_part('epoch', date_trunc('month', '1999-10-01'::timestamp + '1 month
1 hour'::interval))-date_part('epoch', '1999-10-01'::timestamp);
Regards,
Guillaume Perréal - Stagiaire MIAG
Cemagref (URH), Lyon, France
Tél: (+33) 4.72.20.87.64
Hi all,
I think there is a bug in the PostgreSQL date system:
Try computing (replace with some differents years):
'-10-01'::datetime + '1 month'::interval
Depending on the year, you can get '-11-01' as expected or 'XXXX-10-31'
which
