SUBDATE(expr,days): The second form allows the use of an integer value for days : SUBDATE « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. SUBDATE
mysql>
mysql> SELECT SUBDATE('1998-01-02 12:00:00', 31);
+------------------------------------+
| SUBDATE('1998-01-02 12:00:00', 31) |
+------------------------------------+
| 1997-12-02 12:00:00                |
+------------------------------------+
1 row in set (0.00 sec)

mysql>
mysql>








14.40.SUBDATE
14.40.1.SUBDATE(date,INTERVAL expr unit)
14.40.2.SELECT SUBDATE('1998-01-02', INTERVAL 31 DAY);
14.40.3.SUBDATE(expr,days): The second form allows the use of an integer value for days