Vantage performs implicit conversion from CHARACTER to TIME types during assignment and comparison. This conversion is supported for CHAR and VARCHAR types only. You cannot convert a character data type of CLOB or CHAR/VARCHAR CHARACTER SET GRAPHIC to TIME.
Vantage may also perform implicit conversion from TIME to TIMESTAMP types. However, implicit TIME to TIMESTAMP conversion is not supported for comparisons.
You can use CAST to explicitly convert CHARACTER to TIME types or from TIME to TIMESTAMP types.
For more information, see CAST in Explicit Data Type Conversions.