Documentation

Other SQL operators

SQL supports miscellaneous operators that perform various operations.

OperatorMeaning
||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 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

Convert a UTC timestamp to a specified timezone

Add a time zone offset to a timestamp without a specified timezone


Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

New in InfluxDB 3.5

Key enhancements in InfluxDB 3.5 and the InfluxDB 3 Explorer 1.3.

See the Blog Post

InfluxDB 3.5 is now available for both Core and Enterprise, introducing custom plugin repository support, enhanced operational visibility with queryable CLI parameters and manual node management, stronger security controls, and general performance improvements.

InfluxDB 3 Explorer 1.3 brings powerful new capabilities including Dashboards (beta) for saving and organizing your favorite queries, and cache querying for instant access to Last Value and Distinct Value caches—making Explorer a more comprehensive workspace for time series monitoring and analysis.

For more information, check out: