Thanks Greg! I am running on Unix, so this is very helpful. Dana On Sunday, December 22, 2019 at 1:55:16 PM UTC-8, Greg Troxel wrote: > > Dana Roode <dana...@gmail.com <javascript:>> writes: > > > Hello, > > > > I've had some issues with the rain collector on my Vantage Pro2 this > year, > > I replaced it a few weeks back. There were some spurious high readings, > > plus my testing generated false readings. The data indicates over 60 > > inches of rain in my desert location this year. I'd like to find the > bad > > values and zero them out, and I see how to do this with sqlite3 on the > > database if I understood the data fields. "rain" is the field in the > > archive tables, but I don't know what time period thats for. The > dateTime > > field has numbers like 1539650100 and I don't know how to convert to > > something meanful. > > I would guess that rain is either the rain that arrived in that archive > interval, or some sort of cumulative value. > > The dateTime is in seconds since the Unix epoch, which was > 1970-01-01T00:00:00Z (Jan 1, 1970, midnight UTC). > > On Unix, date -r will take that and convert it to human time. This is > just what is does normally, except it uses the provided value vs > gettimeofday(). > > $ date -r 1539650100 > Mon Oct 15 20:35:00 EDT 2018 > > which isn't a few weeks ago. > > On windows, you could install Unix and then run date -r. Probably > there's an easier way... >
-- 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 on the web visit https://groups.google.com/d/msgid/weewx-user/6212715b-9662-4bcc-bf02-4a657d909a1f%40googlegroups.com.