TIME [ AT { LOCAL | [ TIME ZONE ] { expression | time_zone_string } } ]
Syntax Elements
- LOCAL
- The value returned is constructed from the session time and session time zone.
- TIME ZONE
- Use the time zone displacement defined by expression.
- expression
- The data type of expression must be INTERVAL HOUR(2) TO MINUTE or a data type that can be implicitly converted to INTERVAL HOUR(2) TO MINUTE.
- time_zone_string
- time_zone_string determines the time zone displacement.