From: gregor herrmann <gregor@toastfreeware.priv.at>
Date: Thu, 30 Aug 2018 16:45:39 +0000 (+0200)
Subject: for datetime intervals, don't return lowest value (min()) but avg()
X-Git-Url: https://git.toastfreeware.priv.at/chrisu/seepark.git/commitdiff_plain/c078b6b5f231a2e7da614bcc6efcd0bb03c2fbeb?hp=c078b6b5f231a2e7da614bcc6efcd0bb03c2fbeb

for datetime intervals, don't return lowest value (min()) but avg()

needs a conversion to/from unix timestamp

cf. https://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html
and https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
---