The date reported by the agent is generally unreliable. It can have various formats like Y/m/d or m/d/Y (on the same system) or contain garbage like "0000//0/0/00". The server passes this value directly to MySQL which silently accepts any invalid date input and turns it into... a different kind of garbage (0000-00-00).
The agent should try to validate the value and either convert it to a unified format (preferrably ISO8601) or discard unparseable input so that the XML file is consistent.
The date reported by the agent is generally unreliable. It can have various formats like Y/m/d or m/d/Y (on the same system) or contain garbage like "0000//0/0/00". The server passes this value directly to MySQL which silently accepts any invalid date input and turns it into... a different kind of garbage (0000-00-00).
The agent should try to validate the value and either convert it to a unified format (preferrably ISO8601) or discard unparseable input so that the XML file is consistent.