是的,您可以使用date_sub()从日期中减去天数。以下是语法-select date_sub(yourColumnName,Interval yourAmountOfDays day) from yourTableName;
让我们首先创建一个表-create table DemoTable660(AdmissionDate datetime);
使用插入命令在表中插入一些记录-insert into DemoTable660 values('2018-01-24');
insert into DemoTable660 values('2019-07-10');
insert into DemoTable660 values('2020-11-20');
使用select语句显示表中的所有记录-select *from DemoTable660;
这将产生以下输出-+---------------------+
| AdmissionDate |
+---------------------+
| 2018-01-24 00:00:00 |
| 2019-07-10 00:00:00 |
| 2020-11-20 00:00:00 |
+---------------------+
3 rows in set (0.00 sec)
以下是从MySQL中的日期中减去天数的查询-select date_sub(AdmissionDate,Interval 5 day) from DemoTable660;
这将产生以下输出-+----------------------------------------+
| date_sub(AdmissionDate,Interval 5 day) |
+----------------------------------------+
| 2018-01-19 00:00:00 |
| 2019-07-05 00:00:00 |
| 2020-11-15 00:00:00 |
+----------------------------------------+
3 rows in set (0.00 sec)