What units are used for storing data in mysql?
mysql> select SUM(daily_rainfall) from wx_data -> where month > '6' and year = '2004'; +---------------------+ | SUM(daily_rainfall) | +---------------------+ | 341765.0011425 | +---------------------+ 1 row in set (16.02 sec)
I thought it was mm but after conversion doesn’t look right either…
I’ve only just started playing with Mysql, but I think the Daily_rain is a snapshot of daily rain stored at the update frequency.
I store my data each minute and the following query gives only the last record per day and hence the correct answer (in mm)
select SUM(daily_rainfall) from wx_data where month > 6 and year = 2004 and time >= 235900.
Then again I could be completely wrong, however it’s fun trying to figure it out 
yes, it should be mm
hey, thats a nice custom screen there alex!