Device failure and recovery dates can be misleading #5169
Description
I have seen cases where the status_fail_date in the host table is showing before the status_rec_date which would make it appear the devices failed in the future
MariaDB [cacti]> select status_fail_date,status_rec_date from host where description = 'host' \G;
*************************** 1. row ***************************
status_fail_date: 2023-01-16 05:16:10
status_rec_date: 2023-01-16 05:11:06
MariaDB [cacti]> SELECT @@system_time_zone as tz;
+------+
| tz |
+------+
| EDT |
+------+
Timezone is correct on the system and the DB