|Character string expression that represents a date||String must match the 'YYYY-MM-DD' format.|
|Character string expression that represents a time||String must match the 'HH:MI:SS.SSSSSS' format.|
|Floating point type||Value must be a time value encoded with the algorithm HOUR * 10000 + MINUTE * 100 + SECOND.
Only HOUR, MINUTE, and SECOND can be extracted from a floating point value.
Externally created time values can be appropriately encoded and stored in a REAL column to any desired precision if the encoding creates a value representable by REAL without precision loss.
Do not store time values as REAL in any new applications. Instead, use the more rigorously defined ANSI SQL:2011 DateTime data types.
|UDT||UDT must have an implicit cast that casts between the UDT and any of the following predefined types:
To define an implicit cast for a UDT, use the CREATE CAST statement and specify the AS ASSIGNMENT clause. For more information, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
Implicit type conversion of UDTs for system operators and functions, including EXTRACT, is a Teradata extension to the ANSI SQL standard. To disable this extension, set the DisableUDTImplCastForSysFuncOp field of the DBS Control Record to TRUE. See Teradata Vantage™ - Database Utilities , B035-1102 .
For more information on implicit type conversion of UDTs, see "Implicit Type Conversions" in Teradata Vantage™ - Data Types and Literals, B035-1143.
|Not a character string expression or floating point type or UDT||Expression must evaluate to a DateTime or Interval type.|