select coalesce(sum(deltafromoctets),0)
from trans,stats
where stats_id=stats.id
and (timeslicet < '1:05' OR timeslicet > '6:05')
returns a number (9188191930), whereas
select coalesce(sum(deltafromoctets),0)
from trans,stats
where stats_id=stats.id
and (timeslicet < '1:05' OR timeslicet > '6:05')
and timesliced < '01-May-2001'
prints 0 (or null without the coalesce) as does
select coalesce(sum(deltafromoctets),0)
from trans,stats
where stats_id=stats.id
and timesliced < '01-May-2001'
How can this be?
select * from stats where timesliced is null or timeslicet is null
select * from trans where deltafromoctets is null
both retun 0 rows.
stats_id and stats.id are "not null"
timesliced date, timeslicet time, deltrafromoctets bigint.
Any hints?
Cheers,
Patrick