hplsql/src/test/queries/local/cast.sql

CAST('Abc' AS CHAR(1));
CAST('Abc' AS VARCHAR(2));
CAST('Abc' AS CHAR);
CAST(TIMESTAMP '2015-03-12 10:58:34.111' AS CHAR(10))