Vantage performs implicit conversion from CHARACTER to TIMESTAMP WITH TIME ZONE 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 TIMESTAMP WITH TIME ZONE.
Vantage may also perform implicit conversion from TIMESTAMP WITH TIME ZONE to TIME and DATE types. However, implicit TIMESTAMP WITH TIMEZONE to TIME conversion is not supported for comparisons.
You can use CAST to explicitly convert CHARACTER to TIMESTAMP WITH TIME ZONE types and from TIMESTAMP WITH TIME ZONE to TIME or DATE types.
For more information, see CAST in Explicit Data Type Conversions.