UDTs are only supported on the Block File System on the primary cluster. They are not available for the Object File System.
Converts TIME data to UDT data.
ANSI Compliance
This statement is ANSI SQL:2011 compliant.
As an extension to ANSI, CAST permits the use of data attribute phrases such as FORMAT.
Syntax
CAST ( time_expression AS UDT_data_type )
Syntax Elements
- time_expression
The TIME expression to be converted.
- UDT_data_type
The UDT type, followed by any FORMAT, NAMED or TITLE data attribute phrases, to which the expression is to be converted.