date_expression ( [ data_attribute [,...] ] TIMESTAMP [ ( fractional_seconds_precision ) ] [, WITH TIME ZONE ] [ AT { LOCAL | [ TIME ZONE ] { expression | time_zone_string } } ] [, data_attribute [,...] ] )
- date_expression
-
A date expression to be converted.
- data_attribute
- One of the following data attributes:
- FORMAT
- NAMED
- TITLE
- 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.