where created > unix_timestamp(current_date - interval 7 day) reason: efficient use of an index on the created column longneck 2008-04-25 16:36:29 UTC #5 DATE_ADD(start_date, INTERVAL expr unit); The DATE_ADD function takes two arguments: The DATE_ADD function adds an interval to a DATE or DATETIME value. The following illustrates the syntax of the DATE_ADD function:. MySQL DATE_SUB() function subtract a time value (as interval) from a date.

Here is an example that uses date functions. The following query selects all rows with a date_col value from within the last 30 days: .

The query also selects rows with dates that lie … mysql> SELECT something FROM tbl_name-> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;. Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. We’ll describe the complete date arithmetic of this method with the help of simple examples. now()+interval 1 day; Or you can write same logic with date_add() function from MySQL like this − date_add(now(),interval 1 day); Let us use the above concept with MySQL select statement. The query is as follows − mysql> select now()+ interval 1 day; Here is the sample output that increments a day by 1 − The date_sub() is a built-in function of mysql database server which is used to make the difference of a time or date value from a date or datetime value and outputs the result as date or datetime. Syntax: DATE_SUB(date, INTERVAL expr unit) Arguments

DATE_SUB() function. This tutorial explains MySQL DATE_ADD function which adds up a slice of time (in days/hours, e.g., 1 day or 10 days) to the given date. mysql> mysql> select DATE_SUB(curdate(), INTERVAL 1 YEAR); +-----+ | DATE_SUB(curdate(), INTERVAL 1 YEAR) | +-----+ | 2006-07-22 | +-----+ 1 row in set (0.00 sec) Date arithmetic - addition. Summary: in this tutorial, you will learn how to use MySQL DATE_ADD function to add a time value to a DATE or DATETIME value.. Introduction to MySQL DATE_ADD function.

The function accepts two arguments, the first argument passed is starting date or initial date from which the second argument which is the time interval is subtracted argument to generate the output.