Start of change

-20493   A TIMESTAMP WITHOUT TIME ZONE VALUE CANNOT BE ASSIGNED TO A TIMESTAMP WITH TIME ZONE TARGET

Explanation

The statement attempted to assign a timestamp without time zone value to a target that is defined as timestamp with time zone. This error can occur on a FETCH, SELECT INTO, or CALL statement.

System action

The statement cannot be processed.

User response

Change the application to first cast the timestamp without a time zone value to a timestamp with a time zone value before making the assignment to the target.

SQLSTATE

22007

End of change