---
title: Other SQL operators
description: SQL supports other miscellaneous operators that perform various operations.
url: https://docs.influxdata.com/influxdb3/cloud-dedicated/reference/sql/operators/other/
estimated_tokens: 1337
product: InfluxDB Cloud Dedicated
version: cloud-dedicated
---

# 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.

```sql
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](/influxdb3/cloud-dedicated/reference/sql/data-types/#sql-and-arrow-data-types), the operator assumes the time is in the time zone specified. Time zone offsets are provided by the operating system time zone database.

```sql
SELECT time AT TIME ZONE 'America/Los_Angeles' FROM home
```

[](#convert-a-utc-timestamp-to-a-specified-timezone)

Convert a UTC timestamp to a specified timezone

```sql
SELECT
  arrow_cast('2024-01-01 00:00:00', 'Timestamp(Nanosecond, Some("UTC"))')
  AT TIME ZONE 'America/Los_Angeles' AS 'Time with TZ offset'
```

| Time with TZ offset |
| --- |
| 2023-12-31T16:00:00-08:00 |

[](#add-a-time-zone-offset-to-a-timestamp-without-a-specified-timezone)

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

```sql
SELECT
  '2024-01-01 00:00:00' AT TIME ZONE 'America/Los_Angeles' AS 'Local time with TZ offset'
```

| Local time with TZ offset |
| --- |
| 2024-01-01T00:00:00-08:00 |