CREATE/REPLACE CAST Syntax | Teradata Vantage - CREATE CAST and REPLACE CAST Syntax - Advanced SQL Engine - Teradata Database

{ CREATE | REPLACE } CAST ( source AS target )
  WITH { specific_method | specific_function }
  [ AS ASSIGNMENT ] [;]

source

{ source_predefined_data_type | [SYSUDTLIB.] source_UDT_name }

target

{ target_predefined_data_type | [SYSUDTLIB.] target_UDT_name }

specific_method

{ SPECIFIC METHOD specific_method_name |
  [ INSTANCE ] METHOD method_name ( [ data_name | UDT_name ][,...] )
} FOR UDT_name 

specific_function

{ SPECIFIC FUNCTION specific_function_name |
  FUNCTION function_name ([ data_name | UDT_name ][,...])
}