Hi,
I just felt on this one :
create table radlog (
...
debut timestamp,
fin timestamp,
...)
select extract(YEAR FROM debut) as annee,extract(MONTH FROM debut) as
mois, EXTRACT(EPOCH FROM sum(fin-debut)) as total, EXTRACT(EPOCH FROM
avg(fin - debut)) from radlog where fin is not null;
Fails with '0' bas interval external representation for any debut = fin.
This can also be seen with select now() - now();
This is with 7.1.3
I've not been yet able to test with .2.
Is there any quick patch for 7.1.3
Merry Xmas to you all
Regards
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)