SELECT mintime, from_unixtime(dateTime), min from archive_day_outTemp order by min asc, mintime asc limit 20;
Database weewx mintime from_unixtime(dateTime) min NULL 2019-12-15 00:00:00 NULL NULL 2019-12-17 00:00:00 NULL 1606706235 2020-11-30 00:00:00 26.24 1585551900 2020-03-30 00:00:00 27.32 1606689987 2020-11-29 00:00:00 27.5 1575188400 2019-12-01 00:00:00 27.86 1585724700 2020-04-01 00:00:00 28.94 1575533700 2019-12-05 00:00:00 29.66 1585639200 2020-03-31 00:00:00 30.02 1574240700 2019-11-20 00:00:00 30.56 1580890500 2020-02-05 00:00:00 30.92 1607632800 2020-12-10 00:00:00 31.27999999999998 1575153900 2019-11-30 00:00:00 31.28 1579598100 2020-01-21 00:00:00 31.28 1585029900 2020-03-24 00:00:00 31.46 1609479829 2021-01-01 00:00:00 31.46 1575255300 2019-12-02 00:00:00 31.82 1584945300 2020-03-23 00:00:00 31.82 1585116900 2020-03-25 00:00:00 31.82 1607641210 2020-12-11 00:00:00 31.82 Op vrijdag 8 januari 2021 om 21:18:54 UTC+1 schreef [email protected]: > Then adapt as necessary. Use from_unixtime() instead of datetime() in the > select statement. > > On Fri, Jan 8, 2021 at 11:49 AM Arend <[email protected]> wrote: > >> Hello Tom, >> >> I am using MySQL database. >> >> Arend >> >> Op vrijdag 8 januari 2021 om 20:18:20 UTC+1 schreef [email protected]: >> >>> Thanks. Not sure what is happening, but let's take a look at your >>> database. I'm assuming you are using SQLite, and that you used a package >>> installer. You may have to install the tool sqlite3 first >>> >>> sudo apt-get install sqlite3 >>> >>> Then >>> >>> *sqlite3 /var/lib/weewx/weewx.sdb* >>> sqlite> *select mintime, datetime(dateTime,'unixepoch','localtime'), >>> min from archive_day_outTemp order by min asc, mintime asc limit 20;* >>> sqlite> *.quit* >>> >>> Let me know what you get. >>> >>> -tk >>> >>> >>> >>> On Fri, Jan 8, 2021 at 10:01 AM Arend <[email protected]> wrote: >>> >>>> After upgrading from WeeWX 4.1.1 to 4.3.0 Invalid dates started to show >>>> up for mintime. >>>> >>>> In this Belchertown thread the issue is reported by multiple users. >>>> >>>> https://github.com/poblabs/weewx-belchertown/issues/517 >>>> >>>> After replacing the SQL optimizations with the previous "mintime" SQL >>>> strings from WeeWX 4.1.1 the problem was solved. >>>> >>>> Screenshot using optimized (4.3.0) SQL showing invalid dates using >>>> "mintime": >>>> >>>> [image: weewx_belchertown_records_invalid_dates.png] >>>> >>>> Replacing the relevant "mintime" code in xtypes.py with SQL strings >>>> from 4.1.1: >>>> >>>> [image: agg_sql_dict.png] >>>> [image: daily_sql_dict.png] >>>> >>>> Now the previous invalid dates are displayed correctly: >>>> >>>> [image: Records Belchertown na herstel SQL strings.png] >>>> >>>> Haven't tested other SQL optimizations. >>>> >>>> -- >>>> 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/3c48aa67-0850-4f19-af9e-a08527ef8b1cn%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/3c48aa67-0850-4f19-af9e-a08527ef8b1cn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >> 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/d4d920a7-1bd9-4fa7-91d5-d187a6cda3cfn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/d4d920a7-1bd9-4fa7-91d5-d187a6cda3cfn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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/80807b3d-0797-4bc8-b582-013a4e40eacdn%40googlegroups.com.
