Operators Operator

+

Operands & returns

45 overloads

Operator

Overload link	… Varargs	Returns
#01	`ANY[]`	`ANY[]`

… accepts a variable number of arguments of the type shown.

Operator

Operator

Overload link	`left`	`right`	Returns
#15	`BIGINT`	`BIGINT`	`BIGINT`
#16	`BIGNUM`	`BIGNUM`	`BIGNUM`
#17	`DATE`	`INTEGER`	`DATE`
#18	`DATE`	`INTERVAL`	`TIMESTAMP`
#19	`DATE`	`TIME`	`TIMESTAMP`
#20	`DATE`	`TIME WITH TIME ZONE`	`TIMESTAMP WITH TIME ZONE`
#21	`DECIMAL`	`DECIMAL`	`DECIMAL`
#22	`DOUBLE`	`DOUBLE`	`DOUBLE`
#23	`FLOAT`	`FLOAT`	`FLOAT`
#24	`HUGEINT`	`HUGEINT`	`HUGEINT`
#25	`INTEGER`	`DATE`	`DATE`
#26	`INTEGER`	`INTEGER`	`INTEGER`
#27	`INTERVAL`	`DATE`	`TIMESTAMP`
#28	`INTERVAL`	`INTERVAL`	`INTERVAL`
#29	`INTERVAL`	`TIME`	`TIME`
#30	`INTERVAL`	`TIME WITH TIME ZONE`	`TIME WITH TIME ZONE`
#31	`INTERVAL`	`TIMESTAMP`	`TIMESTAMP`
#32	`INTERVAL`	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP WITH TIME ZONE`
#33	`SMALLINT`	`SMALLINT`	`SMALLINT`
#34	`TIME WITH TIME ZONE`	`DATE`	`TIMESTAMP WITH TIME ZONE`
#35	`TIME WITH TIME ZONE`	`INTERVAL`	`TIME WITH TIME ZONE`
#36	`TIME`	`DATE`	`TIMESTAMP`
#37	`TIME`	`INTERVAL`	`TIME`
#38	`TIMESTAMP WITH TIME ZONE`	`INTERVAL`	`TIMESTAMP WITH TIME ZONE`
#39	`TIMESTAMP`	`INTERVAL`	`TIMESTAMP`
#40	`TINYINT`	`TINYINT`	`TINYINT`
#41	`UBIGINT`	`UBIGINT`	`UBIGINT`
#42	`UHUGEINT`	`UHUGEINT`	`UHUGEINT`
#43	`UINTEGER`	`UINTEGER`	`UINTEGER`
#44	`USMALLINT`	`USMALLINT`	`USMALLINT`
#45	`UTINYINT`	`UTINYINT`	`UTINYINT`

SELECT TIME_FROM_PARTS(0, 100, 0)

In DuckDB

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

Used in larger rewrites 1

These examples use + as one part of a larger SQL translation.

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

In DuckDB

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