Hi I am using mysql I ran the command you suggested an got this: MariaDB [weewx]> select max, datetime(maxtime,'unixepoch','localtime') from archive_day_wind where dateTime>1524319200 and dateTime<=1524924000; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(maxtime,'unixepoch','localtime') from archive_day_wind where dateTime>152431920' at line 1
MariaDB [weewx]> select max, datetime from archive_day_wind where dateTime>1524319200 and dateTime<=1524924000;+------------------+------------+ | max | datetime | +------------------+------------+ | 4.80001193419655 | 1524405600 | | 3.70000919927651 | 1524492000 | | 4.80001193419655 | 1524578400 | | 5.40001342597112 | 1524664800 | | 6.50001616089117 | 1524751200 | | 4.10001019379289 | 1524837600 | | 5.40001342597112 | 1524924000 | +------------------+------------+ 7 rows in set (0.01 sec) On Monday, 30 April 2018 00:38:48 UTC+10, Thomas Keffer wrote: > > For stats on a 'week', the data would be stored in the daily summaries. If > you have the start and stop of the week in unix epoch time, you can query > the database directly using the tool sqlite3 and see if the data is in > there. > > For example, for the week 21-28 April, AEST, the start and stop time would > be 1524319200 to 1524924000. If you are not in the AEST time zone, adjust > as necessary. > > In the example, it's assumed you've used the setup.py install method and > the location of your sqlite database is /home/weewx/archive/weewx.sdb. If > you used a Debian install, it will be /var/lib/weewx/weewx.sdb > > You may have to install the tool sqlite3: > > $ *sudo apt install sqlite3* > > then > > $ *sqlite3 /home/weewx/archive/weewx.sdb* > SQLite version 3.11.0 2016-02-15 17:29:24 > Enter ".help" for usage hints. > sqlite> *select max, datetime(maxtime,'unixepoch','localtime') from > archive_day_wind where dateTime>1524319200 and dateTime<=1524924000;* > 9.0|2018-04-22 00:20:00 > 16.0|2018-04-23 15:25:00 > 16.0|2018-04-24 13:45:00 > 11.0|2018-04-25 14:50:00 > 12.0|2018-04-26 14:40:00 > 34.0|2018-04-27 09:51:15 > 16.0|2018-04-28 11:55:00 > sqlite> *.quit* > > This shows the strength and time of the max wind speeds for the seven days > of the week. Try it and see what you get. > > > > > On Sun, Apr 29, 2018 at 2:32 AM, Greg from Oz <[email protected] > <javascript:>> wrote: > >> My web page displays the wind direction and is using this value >> $current.windDir.formatted >> >> The week web page is using this: $week.wind.max from $week.wind.gustdir >> ($week.wind.gustDir.ordinal_compass) at $week.wind.maxtime >> >> This is what is displayed on the current conditions webpage; >> Wind 6 km/h from 217° (SW) >> >> This is what is being displayed on the week webpage: >> High Wind 23 km/h from N/A (N/A) at 11:47:27 (Friday)So my question is >> why doesn't the directions show up on any other webpages? >> Also where is the data for these values stored? >> Are they calculated somewhere? >> >> I noticed this direction data was missing after I installed the android >> weewx app (which is great BTW) and it showed my missing data. >> >> Thanks in advance. >> >> >> -- >> 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 [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
