Re: [GENERAL] timespan

Something interesting I overlooked in my own posting:

One query gives 11688 days, the other 11681.26875 ...

I didn't calculate by hand, but emacs' calendar gives 11688 days,
too.

A simpler example:

=> select date_part ('epoch', age(datetime('29.02.2000','00:00'),
datetime('29.02.1968','00:00')));
date_part
----------
1009843200
^

=> select date_part ('epoch', age(datetime('29.02.2000','00:00'),
datetime('29.02.1968','00:01')));
date_part
----------
1009303140
^

Ulf

--
======================================================================
%%%%% Ulf Mehlig <ulf(dot)mehlig(at)uni-bremen(dot)de>
%%%%!%%% Projekt "MADAM" <umehlig(at)uni-bremen(dot)de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~