有没有一种方法可以从MySQL中的日期中减去天数?
是的,您可以使用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)