Addition and concatenation (+)

Syntax

value_1 + value_2

Description

Behaves differently depending on the argument types. Possible options are listed in the table:

Type of value_1 Type of value_2 Return value
Fractional number | Integer Fractional number | Integer The sum of the numbers value_1 and value_2.
Date Fractional number | Integer The date that is value_2 days greater than value_1 (rounded down to an integer number of days).
Datetime Fractional number | Integer The date with time, value_2 days greater than value_1. If value_2 contains a fractional part, it is converted hours (1/24), minutes (1/1440), and seconds (1/86400).
String String The merging (concatenation) of strings value_1 and value_2.
Array of fractional numbers | Array of integers | Array of strings Array of fractional numbers | Array of integers | Array of strings The merging (concatenation) of arrays value_1 and value_2.

Changing the order of arguments does not affect the result.

Argument types:

  • value_1Array of fractional numbers | Array of integers | Array of strings | Date | Datetime | Fractional number | Integer | Markup | String
  • value_2Array of fractional numbers | Array of integers | Array of strings | Date | Datetime | Fractional number | Integer | Markup | String

Return type: Depends on argument types

Examples

2 + 3 = 5
"Lorem" + " ipsum" = "Lorem ipsum"
#2019-01-06# + 2 = #2019-01-08#
2.2 + #2019-01-06# = #2019-01-08#
2 + #2019-01-06 03# = #2019-01-08 03:00:00#
#2019-01-06 03# + 2.5 = #2019-01-08 15:00:00#

Data source support

ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.

Previous