Other SQL operators
SQL supports miscellaneous operators that perform various operations.
Operator | Meaning | |
---|---|---|
|| | Concatenate strings | |
AT TIME ZONE | Apply a time zone offset |
||
The ||
operator concatenates two string operands into a single string.
SELECT 'Hello' || ' world' AS "Concatenated"
Concatenated |
---|
Hello world |
AT TIME ZONE
The AT TIME ZONE
operator takes the timestamp in the left operand and returns
an equivalent timestamp with the updated time and offset of the time zone
specified in the right operand.
If no time zone is included in the input timestamp’s
Arrow data type,
the operator assumes the time is in the time zone specified.
Time zone offsets are provided by the operating system time zone database.
SELECT time AT TIME ZONE 'America/Los_Angeles' FROM home
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.