-20497 A STRING REPRESENTATION OF A DATETIME VALUE THAT CONTAINS A TIME ZONE CANNOT BE IMPLICITLY OR EXPLICITLY CAST TO A TARGET DEFINED AS DATETIME WITHOUT TIME ZONE
Explanation
The statement attempted to cast a string representation of a datetime value that contains a time zone to a datetime target that is defined to not have a time zone. This action is not supported.
System action
The statement cannot be processed.
User response
Change the application to first cast the string value with a time zone to a datetime value with a time zone, and then cast the result to a datetime value without a time zone. Then make the assignment to the target.
SQLSTATE
22007