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.mehlig@uni-bremen.de>
%%%%!%%% Projekt "MADAM" <umehlig@uni-bremen.de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~
