MySQL date_sub () function

Document directory

• Syntax

MySQL date_sub () function

MySQL date function

Definition and usage

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

Syntax

DATE_SUB(date,INTERVAL expr type)

DateA parameter is a valid date expression.ExprThe parameter is the time interval you want to add.

The type parameter can be of the following values:

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

Instance

Suppose we have the following table:

Orderid	Productname	Orderdate
1	'Computer'	16:25:46. 635

Now, we want to subtract 2 days from "orderdate.

We use the following SELECT statement:

SELECT OrderId,DATE_SUB(OrderDate,INTERVAL 2 DAY) AS OrderPayDateFROM Orders

Result:

Orderid	Orderpaydate
1	2008-12-27 16:25:46. 635

MySQL date function