Find the date a week ago : DATE_SUB « Date Time « SQL / MySQL

1. SQL / MySQL
2. Date Time
3. DATE_SUB

Find the date a week ago

     
mysql>
mysql> SELECT CURDATE( ), DATE_SUB(CURDATE( ),INTERVAL 7 DAY);
+------------+-------------------------------------+
| CURDATE( ) | DATE_SUB(CURDATE( ),INTERVAL 7 DAY) |
+------------+-------------------------------------+
| 2011-10-03 | 2011-09-26                          |
+------------+-------------------------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
    
    
  

Related examples in the same category