docs-v2/content/influxdb/clustered/reference/sql/operators/other.md

title	list_title	description	menu	weight	list_code_example
Other SQL operators	Other operators	SQL supports other miscellaneous operators that perform various operations.	influxdb_clustered name parent Other operators Operators	305	| Operator | Meaning | Example | Result | | :------------: | :----------------------- | :-------------------------------------- | :------------ | | `||` | Concatenate strings | `'Hello' || ' world'` | `Hello world` | | `AT TIME ZONE` | Apply a time zone offset | _[View example](/influxdb/clustered/reference/sql/operators/other/#at-time-zone)_ | |

SQL supports miscellaneous operators that perform various operations.

Operator	Meaning
||	Concatenate strings	{{< icon "link" >}}

||

The || operator concatenates two string operands into a single string.

{{< flex >}} {{% flex-content "two-thirds operator-example" %}}

SELECT 'Hello' || ' world' AS "Concatenated"

{{% /flex-content %}} {{% flex-content "third operator-example" %}}

Concatenated
Hello world

{{% /flex-content %}} {{< /flex >}}

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.

{{% note %}} 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. {{% /note %}}

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