When converting TIME to CHAR(n) or VARCHAR(n), then n must be equal to or greater than the length of the TIME 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 TIME 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 TIME 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 |
TIME to CLOB conversion is not supported.
You cannot convert a TIME value to a character string when the server character set is GRAPHIC.