MYSQL date_sub () function

Definition and usage

The Date_sub () function subtracts the specified time interval from the date.

Grammar

Date_sub (Date,interval expr type)

The date parameter is a valid day expression. The expr parameter is the time interval that you want to add.

The type parameter can be the following value:

Type value
Microsecond
SECOND
MINUTE
HOUR
Day
WEEK
MONTH
QUARTER
Year
Second_microsecond
Minute_microsecond
Minute_second
Hour_microsecond
Hour_second
Hour_minute
Day_microsecond
Day_second
Day_minute
Day_hour
Year_month

Example: Modify Order Time

Update Order_childs Set Create_time=date_sub (Create_time, Interval 1 hour) where child_order_no= ' order number ' and ss_id in (4,73)

Reference URL http://www.w3school.com.cn/sql/func_date_sub.asp

MYSQL date_sub () function