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 |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.