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.
| Target Data Type | n | Result |
|---|---|---|
| CHAR(n) | Greater than length of TIMESTAMP value as represented by character string literal | Trailing pad characters are added to pad representation. |
| Too small | String truncation error is returned. | |
| VARCHAR(n) | Greater than length of TIMESTAMP value as represented by character string literal | No blank padding is added to character representation. |
| Too small | 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.