Course
Simulator
More
Premium
Log in
SQL Function Reference
Functions
TIMESTAMPADD
TIMESTAMPADD
Returns the value after adding one date/time to another date/time
MySQL
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
MySQL
SELECT
TIMESTAMPADD
(
HOUR
,
3
,
"2022-12-05 10:37:22"
)
as
date
;