select max(windSpeed) from archive where dataTime > xxxxxxxxx; (for today) 13.8690394820237
select max(windGust) from archive where dateTime > xxxxxxxxxx; (for today) 15.4348987783812 select max, maxtime from archive_day_wind where dateTime = xxxxxxxxxx; (for today) 15.4348987783812 | 1484308500 select max, maxtime from archive_day_windGust where dateTime = xxxxxxxxx; (for today) 15.4348987783812 | 1484308500 a) miles_per_hour is %.0f b) I looked in both tables c) archive interval is 5 minutes -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.