MessMate Farm, Vic, Australia

❰ WeeWX  - Mesowx  - ❰ Mesowx: DualRain  - ❰ Mesowx: weewx  - ❰ Mesowx: pmon  - ❰ WXgraphic  - ❰ Belchertown

Use the following to select a date for archived records Date style can be either 01-Feb-2018 or 01-02-2018 ( DD-MM-YYYY )

Choose the date:

Time taken to generate page was 0.09 seconds.

SELECT:

SELECT dateTime, rain, rainrate, hail, hailrate FROM archive WHERE dateTime BETWEEN 1666900980 AND 1666901940;
SELECT dateTime, hail FROM archive WHERE hail > 0 AND dateTime BETWEEN 1667426400 AND 1667430000;
SELECT dateTime, rain, rainrate, sum(hail), hailrate FROM archive WHERE dateTime BETWEEN 1667432400 AND 1667434440;
SELECT dateTime, rain, rainrate, hail, raincount1, raincount3, raincount4 FROM archive WHERE dateTime BETWEEN 1667446740 AND 1667447770;
SELECT dateTime, sum(rain), rainrate, hail, raincount1, raincount3, raincount4 FROM archive WHERE dateTime BETWEEN 1667446740 AND 1667447770;
SELECT datetime, rain, hail FROM archive ORDER BY dateTime DESC LIMIT 1;
SELECT hail FROM archive WHERE dateTime = 1667059560 AND hail > 0;

UPDATE:

UPDATE archive SET rain=0, rainrate=0 WHERE datetime BETWEEN 1667059560 AND 1667091300;
UPDATE archive SET rain=1.016, rainrate=0 WHERE datetime BETWEEN 1611873540 AND 1611892800 AND hail=1.016;
UPDATE archive SET rain=0.254 WHERE datetime = 1666901040;

      # supply a date, get an epoch time.

      date -d "11-june-2017 21:00:00" +'%s'
      # 1497178800

      date -d now +'%s'
      # 1667447728

      date +"%s"
      # returns the CURRENT epoch time, ie:- now!

      date -d @1407198071
      # Tue  5 Aug 10:21:11 AEST 2014

    

This extension is available at github as weewx-wxobs : This is version 0.8.1