Hi thomas, 1) The time zone for this season is UTC + 02:00 2) First installed the dependency packages autonomously, then installed weewx from the .DEB repository. I installed both, Sqlite3 and MySQL. 3) I would like to know how to reset the value of rain all day long, and how to change a single value. 4) Also the 'datetime' I see is UNIX time? Do you know of an online portal to calculate it?
2017-04-22 0:29 GMT+02:00 Thomas Keffer <[email protected]>: > We need more information than that. > > What time zone? UTC+02:00? > > How did you install? Using setup.py, or Debian? Or, something else? > > Do you want to zero out all rain data for the day? Or, is there just one > bad value? If just one value, roughly how big is the value? > > Try this and tell me what you get > > cd /var/lib/weewx > echo "SELECT dateTime, rain FROM archive WHERE dateTime > 1492725600 and > dateTime <= 1492812000 AND rain > 0;" | sqlite3 weewx.sdb > > (NB: 1492725600 is midnight 21-04-2017, and 1492812000 is midnight > 22-04-2017 in the time zone UTC+02:00.) > > -tk > > > -tk > > > On Fri, Apr 21, 2017 at 3:09 PM, Massimiliano Neri <[email protected]> > wrote: > >> >> Hello Thomas, I would like to reset the content of the rain of the day on >> 21-04-2017, how can I make the SQL statement? >> >> >> Il giorno venerdì 21 aprile 2017 21:00:32 UTC+2, Massimiliano Neri ha >> scritto: >>> >>> I am using Weewx for 2 weeks, I need to correct the amount of rain fall, >>> either daily, monthly and annually. You can tell me the procedure for >>> making these fixes. thank you. >>> >>> -- >> 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. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/weewx-user/EQ3Cuyxx7Mg/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- *Massimiliano Neri * Via del Castello 4 - 05015 Fabro (TR) - ITALY. Phone: +39 339 1997334 Fax: +39 0763 831347 E-mail PEC: [email protected] Visita il sito: http://meteofabro.altervista.org <http://meteofabro.altervista.org/plugins/stickers/sticker800_170.php?parameter=T&text=Hello&color1=grey&color2=teal> -- 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.
