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 if the DBS Control flag TimeDateWZControl is enabled.
- If TimeDateWZControl is disabled, the value returned is constructed from the time value local to Vantage and the session time zone.
- TIME ZONE
- Use the time zone displacement defined by expression.
- 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.
- time_zone_string
- time_zone_string determines the time zone displacement.