I tried getting the value for the day on which 51,5 km/h was the top speed but it results in: sqlite> SELECT max ...> FROM archive_day_windGust ...> WHERE date(datetime(dateTime, 'unixepoch')) = '2024-11-19' ...> ORDER BY max DESC; 21.0 and sqlite> SELECT max FROM archive_day_wind WHERE date(datetime(dateTime, 'unixepoch')) = '2024-11-19' ORDER BY max DESC LIMIT 5; 21.0
Maybe I just switch to a new skin. I just noticed that i use this db schema: user.weatherlink_live.schema Is there any way how I can transition to the default wview-extended with weectl database? michael.k...@gmx.at schrieb am Samstag, 11. Januar 2025 um 15:57:25 UTC+1: > What's the value in the max column in archive_day_windGust table? > What's the value in the max column in archive_day_wind table? > > Are you sure that wind.max is what you want to know? Or rather > windGust.max? > > Paul schrieb am Samstag, 11. Januar 2025 um 14:10:28 UTC+1: > >> Hi, >> >> In my NOAA report it has as "HIGH" 51,5 km/h but in the month html >> representation it shows 51 km/h as highest speed. So my question now is >> which one of them is mathematically correct? Either the value in DB is >> 51,48 which would then result in 51,5 for the txt report but in the html is >> would just use 51,4 which results in 51... >> >> So the code used is "$day.wind.max.format($Wind,$NONE,add_label=False)" >> for the NOAA and "$month.wind.max" for the html tmpl. >> >> Many thanks, >> Paul >> > -- 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. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/5c05e4de-d3e1-49d7-93bf-0ed863208132n%40googlegroups.com.