Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. To shift a date forward or backward a week (seven days), use TO_DAYS( ) and FROM_DAYS( )
mysql>
mysql>
mysql>
mysql> SET @d = '2002-01-01';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT @d AS date,
    -> FROM_DAYS(TO_DAYS(@d) + 7) AS 'date + 1 week',
    -> FROM_DAYS(TO_DAYS(@d) - 7) AS 'date - 1 week';
+------------+---------------+---------------+
| date       | date + 1 week | date - 1 week |
+------------+---------------+---------------+
| 2002-01-01 | 2002-01-08    | 2001-12-25    |
+------------+---------------+---------------+
1 row in set (0.00 sec)
mysql>