Ads were blocked by your webbrowser.

This is not a 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 10.1.0.5464?

ByterBit's profile image ByterBit posted 2 weeks ago in General

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 9.5.0.5196 gives NULL as does a recent install of DBever.

ansgar's profile image ansgar posted 2 weeks ago

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.