date_add
function
Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above
Adds value
and unit
to a timestamp expr
. This function is a synonym for timestampadd function.
Syntax
date_add(unit, value, expr)
unit
{ MICROSECOND |
MILLISECOND |
SECOND |
MINUTE |
HOUR |
DAY | DAYOFYEAR |
WEEK |
MONTH |
QUARTER |
YEAR }
Arguments
unit
: A unit of measure.value
: A numeric expression with the number ofunit
s to add toexpr
.expr
: A TIMESTAMP expression.