I just got the MariaDB and phpMyAdmin add-ons installed and I’m excited for the possibility of keeping a long term database with data aggregated by date. For example, Electricity usage per day, min/max temperatures, time HVAC runs, etc.
To do this daily aggregation, I need to convert from UTC to local time and then perform the calculations . I was hoping to use CONVERT_TZ() but I cannot get it to work. I cannot figure out how to get the time zone info into the MySQL tables. Does anybody have any advice or a tutorial on how to do this?
Thanks,