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.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
  ~~~~~~~~~~~~~~~~~~~~