OK, that matches what the historical extension is giving.
A few more selects to try
select date(dateTime,'unixepoch','localtime'),
datetime(`maxtime`,'unixepoch','localtime'),`max` from archive_day_outTemp
where strftime("%m-%d", dateTime,'unixepoch','localtime')='04-05';
select datetime(dateTime,'unixepoch','localtime'),outTemp from archive
where dateTime >1175756400 and dateTime<=1175842800 order by outTemp desc
limit 1;
select datetime(dateTime,'unixepoch','localtime'),outTemp from archive
where dateTime >1175842800 and dateTime<=1175929200 order by outTemp desc
limit 1;
On Sun, Apr 5, 2020 at 1:09 PM Vince Skahan <[email protected]> wrote:
> 2007-04-05|79.0
> 2008-04-05|51.3
> 2009-04-05|71.199997
> 2010-04-05|52.400002
> 2011-04-05|47.7
> 2012-04-05|55.0
> 2013-04-05|53.7
> 2014-04-05|58.4
> 2015-04-05|57.6
> 2016-04-05|65.9
> 2017-04-05|59.6
> 2018-04-05|68.3
> 2019-04-05|55.5
> 2020-04-05|56.6
>
>
> On Sun, Apr 5, 2020 at 1:02 PM Thomas Keffer <[email protected]> wrote:
>
>> can you try the query directly?
>>
>> select date(dateTime,'unixepoch','localtime'), `max` from
>> archive_day_outTemp where strftime("%m-%d",
>> dateTime,'unixepoch','localtime')='04-05';
>>
>> This will tell us the max for each year on 5 April.
>>
>> -tk
>>
>> On Sun, Apr 5, 2020 at 10:37 AM Vince Skahan <[email protected]>
>> wrote:
>>
>>> Finally got around to installing this - too fun !
>>>
>>> Possible bug report - my historical max day as reported by the extention
>>> is off by a day in the extension vs. the NOAA report.
>>>
>>> Look at https://www.skahan.net/weewx/index.html in the Current
>>> Conditions section of the table for the Historical high and compare it with
>>> the NOAA reports for that month. The extension reports things as 79.0 F
>>> today (April 5) when the NOAA report has that for April 6. Off by one
>>> error or a timezone anomaly perhaps ?
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "weewx-development" 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-development/c3f7bd0f-45ea-47a6-9a92-fb52b11594a9%40googlegroups.com
>>> <https://groups.google.com/d/msgid/weewx-development/c3f7bd0f-45ea-47a6-9a92-fb52b11594a9%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>
>
> --
> ----- [email protected] ----
>
--
You received this message because you are subscribed to the Google Groups
"weewx-development" 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-development/CAPq0zEDxcG1eaKdXZ3LtGyyky%2B9ux7y_-FjSKJJu5k8Y7oTCxA%40mail.gmail.com.
