ANSI Compliance
This statement is ANSI SQL:2011 compliant.
As an extension to ANSI, CAST permits the use of data attributes, such as the FORMAT phrase that enables alternative output formatting for the time data.
TIME (without time zone) is not ANSI SQL:2011 compliant. Vantage internally converts a TIME value to UTC based on the current session time zone or on a specified time zone.
Syntax
CAST ( character_expression AS TIME [ ( fractional_seconds_precision ) ] [ WITH TIME ZONE ] [ data_attribute [...] ] )
Syntax Elements
- character_expression
A character expression to be converted.
- fractional_seconds_precision
A single digit representing the number of significant digits in the fractional portion of the SECOND field. The valid range is 0 through 6. The default is 6.
- data_attribute
- One of the following data attributes:
- FORMAT
- NAMED
- TITLE