you need to replace x with an actual epoch date time value! so, for example: delete from archive where dateTime > 1561983540;
to convert a date / time into an epoch date use a site such as: https://www.freeformatter.com/epoch-timestamp-to-date-converter.html On Sunday, 7 July 2019 15:08:15 UTC+3, Eric Gammeter wrote: > > No joy- It is stopped. > > pi@raspberrypi:/var/lib/weewx $ sqlite3 /var/lib/weewx/weewx.sdb > SQLite version 3.16.2 2017-01-06 16:32:41 > Enter ".help" for usage hints. > sqlite> delete from archive where dateTime > x; > Error: no such column: x > sqlite> > > > > > > > > On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote: >> >> Hi- My INDEX.HTML file is being produced each half hour as it should >> be...but the timestamp (in the file) is incorrect! The report (attached) >> shows it is 8/6/2036 @ 08:22:00PM. >> >> I can see that the reports fire off every 30 mins- and that a new >> (correct time stamp) INDEX.HTML file is created in the /var/www/html/weewx >> filesystem-- but that file's info is incorrect. >> >> I tested (with minicom) and that TEST's fine. >> >> I have shutdown and rebooted the VantageVue station to no avail. >> >> Thanks for reading! >> >> /Eric >> > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/cb6da8fc-c972-4d41-a48e-5aee0ceab63c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
