ANSI Compliance
This statement is ANSI SQL:2011 compliant.
As an extension to ANSI, CAST permits the use of the FORMAT phrase to enable alternative output formatting of timestamp data.
The AT clause is ANSI SQL:2011 compliant.
As an extension to ANSI, the AT clause is supported when converting from DATE to TIMESTAMP using CAST. In addition, you can specify the time zone displacement using additional expressions besides an INTERVAL expression.
Syntax
CAST ( date_expression AS TIMESTAMP [ ( fractional_seconds_precision ) ] [ WITH TIME ZONE ] [ AT { LOCAL | [ TIME ZONE ] { expression | time_zone_string } } ] [ data_attribute [...] ] )
Syntax Elements
- date_expression
A date 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.
- AT LOCAL
Use the time zone displacement based on the current session time zone.
- AT [TIME ZONE] expression
Use the time zone displacement defined by expression.
The data type of expression should be INTERVAL HOUR(2) TO MINUTE or it must be a data type that can be implicitly converted to INTERVAL HOUR(2) TO MINUTE.
- AT [TIME ZONE] time_zone_string
- time_zone_string determines the time zone displacement.
- data_attribute
- One of the following data attributes:
- FORMAT
- NAMED
- TITLE