I set up a mysql sensor whit following sql code:
SELECT * FROM `shop_cron_monitoring` WHERE `cron_name` != "cron_zap_import" AND `end_time` < DATE_SUB(NOW(),INTERVAL 24 HOUR) OR `cron_check` = "1"
I receive an error: "[System.String] value can not be parsed. Please keep in mind that any date or time formats need to use the "EN-US" format."
In the log is written: "Unable to convert MySQL date/time value to System.DateTime"
In the setting of "My Account" the timezone is right (UTC +01:00), and Dateformat is "System Settings", which is TT.MM.JJJJ (24h)
What can i do?