SQL Function Reference

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

Examples

MySQL

SELECT TIMESTAMPADD(HOUR, 3, "2022-12-05 10:37:22") as date;