Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Bug? With date INTERVAL? Just in

ByterBit's profile image ByterBit posted 5 months ago in General Permalink

This query falsely returns 0.0617:

SELECT SUM(TIME)/3600 FROM idletimehistory WHERE idle =1 and TIMESTAMP >= NOW() - INTERVAL 30 DAY AND vehicleid IN (select id from vehicles where fleetid =2000)

Using MYSQL server on the command line it returns NULL, as it should.

Also Heidi gives NULL as does a recent install of DBever.

ansgar's profile image ansgar posted 5 months ago Permalink

Without having your idletimehistory and vehicles tables, I am not able to verify that. Probably you can post minimal structure and data here.

Please login to leave a reply, or register at first.