Other SQL operators
SQL supports miscellaneous operators that perform various operations.
| Operator | Meaning | |
|---|---|---|
|| |
Concatenate strings |
||
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 applies the offset of the specified time zone to a
timestamp type and returns an updated UTC timestamp. Time zone offsets are
provided by the the operating system time zone database.
Timestamp types in InfluxDB always represent a UTC time. The returned timestamp is a UTC timestamp adjusted for the offset of the specified time zone.
SELECT
'2024-01-01 00:00:00'::TIMESTAMP AT TIME ZONE 'America/Los_Angeles' AS 'UTC with TZ offset'
| UTC with TZ offset |
|---|
| 2024-01-01T08:00:00.000Z |
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.