Mysql date_sub date_add function usage

Mysql date_sub date_add function usage mysqldate_subdate_add definition and usage DATE_SUB () function minus the specified time interval from date. The syntax DATE_SUB (date, INTERVAL expr type) date parameter is a valid date expression. The expr parameter is the time interval you want to add. The type parameter can be of the following values:

Type Value

 

For example:

Select f_id, date_sub (f_uptime, INTERVAL, 2, HOUR) from t_match; update t_user_ticket set f_validtime = DATE_ADD (f_intime, INTERVAL 3 DAY) where f_ticket in (185,186 );