Mysqldate_subdate_add function usage _ MySQL

Mysqldate_subdate_add function usage bitsCN.com

Mysql date_sub date_add function usage

Mysqldate_subdate_add

Definition and usage

The DATE_SUB () function minus the specified time interval from date.

Syntax

DATE_SUB (date, INTERVAL expr type)

The 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 );

BitsCN.com