Datetime operands

A DATE type is compatible with another DATE type or any character string expression that contains a valid string representation of a date. A string representation must not be a CLOB. The data type of the result is DATE.

A TIME type is compatible with another TIME type or any character string expression that contains a valid string representation of a time. A string representation must not be a CLOB. The data type of the result is TIME.

A TIMESTAMP type is compatible with another TIMESTAMP type or any character string expression that contains a valid string representation of a timestamp. A string representation must not be a CLOB. The data type of the result is TIMESTAMP.

If one operand column is... And the other operand is... The data type of the result column is...
DATE DATE, CHAR(y), or VARCHAR(y) DATE
TIME TIME, CHAR(y), or VARCHAR(y) TIME
TIMESTAMP TIMESTAMP, CHAR(y), or VARCHAR(y) TIMESTAMP