Premium
Log in
TIMESTAMPADD
Returns the value after adding one date/time to another date/time
TIMESTAMPADD(unit, value, datetime)unit
Added time interval. One of the following values MICROSECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR
value
Number of specified intervals added
datetime
Source date/time
| Type | Description |
|---|---|
| MICROSECOND | Microseconds |
| SECOND | Seconds |
| MINUTE | Minutes |
| HOUR | Hours |
| DAY | Days |
| WEEK | Weeks |
| MONTH | Months |
| QUARTER | Quarter |
| YEAR | Years |
Examples
SELECT TIMESTAMPADD(HOUR, 3, "2022-12-05 10:37:22") as date;String functions 18
Date and time functions 19