# + — DuckDB 2.0.0

No description supplied by the engine.

- Reference: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/
- JSON: /products/haybarn/functions/api/v1/duckdb-2.0.0/functions/operator-2b.json
- Snapshot ID: duckdb-2.0.0
- Engine: duckdb v2.0.0
- Source ID: d54cbbe3df
- Binary SHA-256: 4d5d001f4b0a16c16f1bc83338153a70bec7e58f0cae0eec4b44b9b9afa0bef0
- Captured: 2026-11-06T18:35:28.343Z
- Source: https://github.com/duckdb/duckdb/releases/tag/v2.0.0
- Loaded extensions: autocomplete, core_functions, icu, json, parquet, shell

## Interpretation

- Choose a snapshot matching the target engine and build. The default is captured from the published Haybarn WASM package used by the browser playground. Historical native snapshots are also available.
- Availability is an observation in the recorded build and extension profile, not a guarantee of support in every installation or in WASM.
- Types and descriptions are declarations from duckdb_functions(). Binding can specialize result types. Null means not supplied by the catalog; do not invent defaults, optionality, argument mode, or table output columns.
- Raw parameter arrays preserve catalog order for scalar/aggregate/macro functions. Raw table arguments are alphabetical. Use callingConvention for engine-confirmed positional order and named arguments; null modes are unrecorded. Named does not mean optional. Macro defaults and special named variadic behavior are not supplied by duckdb_functions().
- Catalog examples are source material and may require data or extensions. runnableExamples contains separately verified SQL for the pinned WASM package; sample-data adaptations and guide examples are labeled separately.
- Guide annotations and recipes are separate editorial content. The browser runner always uses Haybarn WASM 2.0.0-rc12, independently of the documentation snapshot.
- All URLs beginning with / are relative to the origin hosting this document. Exports require no JavaScript, cookies, API key, or browser engine.

## Overloads

### overload-c040be713005cabd

Kind: scalar. Parameter order: catalog-order.

```text
+(…: ANY[]) → ANY[]
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-c040be713005cabd

| Argument | Catalog type | Calling mode |
| --- | --- | --- |

Declared return type: ANY[]. Variadic argument type: ANY[].
Stability: CONSISTENT. Declared side effects: false.

### overload-d2fe1ed21f3c7be5

Kind: scalar. Parameter order: catalog-order.

```text
+x: BIGINT → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-d2fe1ed21f3c7be5

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | BIGINT | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-5a899552c47d2251

Kind: scalar. Parameter order: catalog-order.

```text
+x: DECIMAL → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-5a899552c47d2251

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | DECIMAL | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-37f1ef13caa1ba0b

Kind: scalar. Parameter order: catalog-order.

```text
+x: DOUBLE → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-37f1ef13caa1ba0b

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | DOUBLE | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-7b67660431ecc657

Kind: scalar. Parameter order: catalog-order.

```text
+x: FLOAT → FLOAT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-7b67660431ecc657

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | FLOAT | not recorded |

Declared return type: FLOAT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-ee75650207864eb8

Kind: scalar. Parameter order: catalog-order.

```text
+x: HUGEINT → HUGEINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-ee75650207864eb8

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | HUGEINT | not recorded |

Declared return type: HUGEINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-c04bd39459448086

Kind: scalar. Parameter order: catalog-order.

```text
+x: INTEGER → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-c04bd39459448086

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | INTEGER | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-77042cc7154f629e

Kind: scalar. Parameter order: catalog-order.

```text
+x: SMALLINT → SMALLINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-77042cc7154f629e

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | SMALLINT | not recorded |

Declared return type: SMALLINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-1684661e3eb26f1b

Kind: scalar. Parameter order: catalog-order.

```text
+x: TINYINT → TINYINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-1684661e3eb26f1b

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | TINYINT | not recorded |

Declared return type: TINYINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-ecb8ef63cb24b921

Kind: scalar. Parameter order: catalog-order.

```text
+x: UBIGINT → UBIGINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-ecb8ef63cb24b921

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | UBIGINT | not recorded |

Declared return type: UBIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-474b9b46ce54d442

Kind: scalar. Parameter order: catalog-order.

```text
+x: UHUGEINT → UHUGEINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-474b9b46ce54d442

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | UHUGEINT | not recorded |

Declared return type: UHUGEINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-16bbc154635035fc

Kind: scalar. Parameter order: catalog-order.

```text
+x: UINTEGER → UINTEGER
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-16bbc154635035fc

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | UINTEGER | not recorded |

Declared return type: UINTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e67993f1aac84355

Kind: scalar. Parameter order: catalog-order.

```text
+x: USMALLINT → USMALLINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-e67993f1aac84355

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | USMALLINT | not recorded |

Declared return type: USMALLINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-d439a8b1908396ab

Kind: scalar. Parameter order: catalog-order.

```text
+x: UTINYINT → UTINYINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-d439a8b1908396ab

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| x | UTINYINT | not recorded |

Declared return type: UTINYINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-9910d38aeaf7974e

Kind: scalar. Parameter order: catalog-order.

```text
left: BIGINT + right: BIGINT → BIGINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-9910d38aeaf7974e

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | BIGINT | not recorded |
| right | BIGINT | not recorded |

Declared return type: BIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-6093ecea1c3dc525

Kind: scalar. Parameter order: catalog-order.

```text
left: BIGNUM + right: BIGNUM → BIGNUM
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-6093ecea1c3dc525

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | BIGNUM | not recorded |
| right | BIGNUM | not recorded |

Declared return type: BIGNUM. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-4dee5a81885c6d2c

Kind: scalar. Parameter order: catalog-order.

```text
left: DATE + right: INTEGER → DATE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-4dee5a81885c6d2c

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | DATE | not recorded |
| right | INTEGER | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-ca9e5007fd45c98d

Kind: scalar. Parameter order: catalog-order.

```text
left: DATE + right: INTERVAL → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-ca9e5007fd45c98d

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | DATE | not recorded |
| right | INTERVAL | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-2b8c2921d50b46ed

Kind: scalar. Parameter order: catalog-order.

```text
left: DATE + right: TIME → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-2b8c2921d50b46ed

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | DATE | not recorded |
| right | TIME | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-a6b16c95a97d316b

Kind: scalar. Parameter order: catalog-order.

```text
left: DATE + right: TIME WITH TIME ZONE → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-a6b16c95a97d316b

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | DATE | not recorded |
| right | TIME WITH TIME ZONE | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-8ba3d0cadbe427e2

Kind: scalar. Parameter order: catalog-order.

```text
left: DECIMAL + right: DECIMAL → DECIMAL
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-8ba3d0cadbe427e2

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | DECIMAL | not recorded |
| right | DECIMAL | not recorded |

Declared return type: DECIMAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-9364f4c756a3c5a6

Kind: scalar. Parameter order: catalog-order.

```text
left: DOUBLE + right: DOUBLE → DOUBLE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-9364f4c756a3c5a6

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | DOUBLE | not recorded |
| right | DOUBLE | not recorded |

Declared return type: DOUBLE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-33dade7a12cc90d0

Kind: scalar. Parameter order: catalog-order.

```text
left: FLOAT + right: FLOAT → FLOAT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-33dade7a12cc90d0

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | FLOAT | not recorded |
| right | FLOAT | not recorded |

Declared return type: FLOAT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-a6f4eb3ecd2258e2

Kind: scalar. Parameter order: catalog-order.

```text
left: HUGEINT + right: HUGEINT → HUGEINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-a6f4eb3ecd2258e2

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | HUGEINT | not recorded |
| right | HUGEINT | not recorded |

Declared return type: HUGEINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-8fa167f76966e04a

Kind: scalar. Parameter order: catalog-order.

```text
left: INTEGER + right: DATE → DATE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-8fa167f76966e04a

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | INTEGER | not recorded |
| right | DATE | not recorded |

Declared return type: DATE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-236ed4f93b2832ce

Kind: scalar. Parameter order: catalog-order.

```text
left: INTEGER + right: INTEGER → INTEGER
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-236ed4f93b2832ce

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | INTEGER | not recorded |
| right | INTEGER | not recorded |

Declared return type: INTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-a237d77f47a3a39d

Kind: scalar. Parameter order: catalog-order.

```text
left: INTERVAL + right: DATE → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-a237d77f47a3a39d

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | INTERVAL | not recorded |
| right | DATE | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-6a56af96cf7a11b2

Kind: scalar. Parameter order: catalog-order.

```text
left: INTERVAL + right: INTERVAL → INTERVAL
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-6a56af96cf7a11b2

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | INTERVAL | not recorded |
| right | INTERVAL | not recorded |

Declared return type: INTERVAL. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-edacff5531133b12

Kind: scalar. Parameter order: catalog-order.

```text
left: INTERVAL + right: TIME → TIME
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-edacff5531133b12

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | INTERVAL | not recorded |
| right | TIME | not recorded |

Declared return type: TIME. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-238f042827710830

Kind: scalar. Parameter order: catalog-order.

```text
left: INTERVAL + right: TIME WITH TIME ZONE → TIME WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-238f042827710830

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | INTERVAL | not recorded |
| right | TIME WITH TIME ZONE | not recorded |

Declared return type: TIME WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b6cffe5ed274cbff

Kind: scalar. Parameter order: catalog-order.

```text
left: INTERVAL + right: TIMESTAMP → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-b6cffe5ed274cbff

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | INTERVAL | not recorded |
| right | TIMESTAMP | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-5e29df91d012b21f

Kind: scalar. Parameter order: catalog-order.

```text
left: INTERVAL + right: TIMESTAMP WITH TIME ZONE → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-5e29df91d012b21f

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | INTERVAL | not recorded |
| right | TIMESTAMP WITH TIME ZONE | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e8c9fc78195347ad

Kind: scalar. Parameter order: catalog-order.

```text
left: SMALLINT + right: SMALLINT → SMALLINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-e8c9fc78195347ad

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | SMALLINT | not recorded |
| right | SMALLINT | not recorded |

Declared return type: SMALLINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-2391fb098ecdf61b

Kind: scalar. Parameter order: catalog-order.

```text
left: TIME WITH TIME ZONE + right: DATE → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-2391fb098ecdf61b

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | TIME WITH TIME ZONE | not recorded |
| right | DATE | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-be15869231f1479c

Kind: scalar. Parameter order: catalog-order.

```text
left: TIME WITH TIME ZONE + right: INTERVAL → TIME WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-be15869231f1479c

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | TIME WITH TIME ZONE | not recorded |
| right | INTERVAL | not recorded |

Declared return type: TIME WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-f1937f3c5bbcc0c8

Kind: scalar. Parameter order: catalog-order.

```text
left: TIME + right: DATE → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-f1937f3c5bbcc0c8

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | TIME | not recorded |
| right | DATE | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-9fade7ecf2425935

Kind: scalar. Parameter order: catalog-order.

```text
left: TIME + right: INTERVAL → TIME
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-9fade7ecf2425935

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | TIME | not recorded |
| right | INTERVAL | not recorded |

Declared return type: TIME. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-42977529ecc2dcae

Kind: scalar. Parameter order: catalog-order.

```text
left: TIMESTAMP WITH TIME ZONE + right: INTERVAL → TIMESTAMP WITH TIME ZONE
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-42977529ecc2dcae

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | TIMESTAMP WITH TIME ZONE | not recorded |
| right | INTERVAL | not recorded |

Declared return type: TIMESTAMP WITH TIME ZONE. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e4291cebd19fd113

Kind: scalar. Parameter order: catalog-order.

```text
left: TIMESTAMP + right: INTERVAL → TIMESTAMP
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-e4291cebd19fd113

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | TIMESTAMP | not recorded |
| right | INTERVAL | not recorded |

Declared return type: TIMESTAMP. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-5ab4948f8a360167

Kind: scalar. Parameter order: catalog-order.

```text
left: TINYINT + right: TINYINT → TINYINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-5ab4948f8a360167

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | TINYINT | not recorded |
| right | TINYINT | not recorded |

Declared return type: TINYINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-b0a2bf68bbb7e361

Kind: scalar. Parameter order: catalog-order.

```text
left: UBIGINT + right: UBIGINT → UBIGINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-b0a2bf68bbb7e361

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | UBIGINT | not recorded |
| right | UBIGINT | not recorded |

Declared return type: UBIGINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-286ec997957018d4

Kind: scalar. Parameter order: catalog-order.

```text
left: UHUGEINT + right: UHUGEINT → UHUGEINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-286ec997957018d4

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | UHUGEINT | not recorded |
| right | UHUGEINT | not recorded |

Declared return type: UHUGEINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-be731fc56f759fd7

Kind: scalar. Parameter order: catalog-order.

```text
left: UINTEGER + right: UINTEGER → UINTEGER
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-be731fc56f759fd7

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | UINTEGER | not recorded |
| right | UINTEGER | not recorded |

Declared return type: UINTEGER. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-e5e0dbd5fd7cbc33

Kind: scalar. Parameter order: catalog-order.

```text
left: USMALLINT + right: USMALLINT → USMALLINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-e5e0dbd5fd7cbc33

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | USMALLINT | not recorded |
| right | USMALLINT | not recorded |

Declared return type: USMALLINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.

### overload-439982d31fe18326

Kind: scalar. Parameter order: catalog-order.

```text
left: UTINYINT + right: UTINYINT → UTINYINT
```

Link: /products/haybarn/functions/releases/duckdb-2.0.0/operator-2b/#overload-439982d31fe18326

| Argument | Catalog type | Calling mode |
| --- | --- | --- |
| left | UTINYINT | not recorded |
| right | UTINYINT | not recorded |

Declared return type: UTINYINT. Variadic argument type: none declared.
Stability: CONSISTENT. Declared side effects: false.


## Guide recipes

No guide recipes.

## Engine catalog examples

Source examples may require additional data or extensions. Expressions are wrapped in SELECT; execution verification is not recorded.

No catalog examples.

## Additional DuckDB documentation

- [Functions](https://duckdb.org/docs/current/sql/functions/overview)

## In other engines

### SQL Server: datetimefromparts()

Uses + as part of a larger rewrite.

SQL Server:

```sql
SELECT DATETIMEFROMPARTS(2013, 4, 5, 12, 00, 00, 0)
```

Haybarn / DuckDB:

```sql
SELECT MAKE_TIMESTAMP(2013, 4, 5, 12, 00, 00 + (0 / 1000.0))
```

Translation from [SQLGlot](https://github.com/tobymao/sqlglot/blob/3086608e6fd4c41c02dfba47171608d2b193fce2/tests/dialects/test_tsql.py#L150).

### Snowflake: time_from_parts()



Snowflake:

```sql
SELECT TIME_FROM_PARTS(0, 100, 0)
```

Haybarn / DuckDB:

```sql
SELECT CAST('00:00:00' AS TIME) + INTERVAL ((0 * 3600) + (100 * 60) + 0) SECOND
```

Translation from [SQLGlot](https://github.com/tobymao/sqlglot/blob/3086608e6fd4c41c02dfba47171608d2b193fce2/tests/dialects/test_snowflake.py#L1357).

## Observed availability

| Snapshot | Observed | Overloads | JSON |
| --- | --- | --- | --- |
| haybarn-2.0.0-rc12 | present | 45 | [reference](/products/haybarn/functions/api/v1/haybarn-2.0.0-rc12/functions/operator-2b.json) |
| haybarn-2.0.0-rc11 | present | 45 | [reference](/products/haybarn/functions/api/v1/haybarn-2.0.0-rc11/functions/operator-2b.json) |
| haybarn-2.0.0-rc8 | present | 45 | [reference](/products/haybarn/functions/api/v1/haybarn-2.0.0-rc8/functions/operator-2b.json) |
| haybarn-1.5.5-rc3 | present | 45 | [reference](/products/haybarn/functions/api/v1/haybarn-1.5.5-rc3/functions/operator-2b.json) |
| haybarn-1.5.6-rc6 | present | 45 | [reference](/products/haybarn/functions/api/v1/haybarn-1.5.6-rc6/functions/operator-2b.json) |
| duckdb-2.0.0 | present | 45 | [reference](/products/haybarn/functions/api/v1/duckdb-2.0.0/functions/operator-2b.json) |
| duckdb-1.5.6 | present | 45 | [reference](/products/haybarn/functions/api/v1/duckdb-1.5.6/functions/operator-2b.json) |
| duckdb-1.5.5 | present | 45 | [reference](/products/haybarn/functions/api/v1/duckdb-1.5.5/functions/operator-2b.json) |
| duckdb-1.4.4 | present | 45 | [reference](/products/haybarn/functions/api/v1/duckdb-1.4.4/functions/operator-2b.json) |
| duckdb-1.3.2 | present | 44 | [reference](/products/haybarn/functions/api/v1/duckdb-1.3.2/functions/operator-2b.json) |

Engine catalog documentation is derived from MIT-licensed Haybarn and DuckDB. [Notices](/third-party-notices.txt).
