When converting TIMESTAMP to CHAR(n) or VARCHAR(n), then n must be equal to or greater than the length of the TIMESTAMP value as represented by a character string literal.
IF the target data type is … | AND n is … | THEN … |
---|---|---|
CHAR(n) | greater than the length of the TIMESTAMP value as represented by a character string literal | trailing pad characters are added to pad the representation. |
too small | a string truncation error is returned. | |
VARCHAR(n) | greater than the length of the TIMESTAMP value as represented by a character string literal | no blank padding is added to the character representation. |
too small | a string truncation error is returned. |
TIMESTAMP to CLOB conversion is not supported.
You cannot convert a TIME value to a character string if the server character set is GRAPHIC.