0613

mysql查询时间select * from files where fname=date_format(date_sub(curdate(),interval 2 day),'%Y%m%d');

mysql> select * from files where date_format(date_sub(curdate(),interval 2 day),'%Y%m%d');
+----+----------+--------+
| id | fname    | 校长   |
+----+----------+--------+
|  1 | 文件01   | RWO    |
|  2 | 文件02   | RW     |
|  3 | 20190612 | RW2    |
|  4 | 20190612 | RW3    |
|  5 | 20190611 | RW3    |
|  6 | 20190610 | RW3    |
+----+----------+--------+
6 rows in set (0.00 sec)

mysql> select * from files where fname=date_format(date_sub(curdate(),interval 2 day),'%Y%m%d');
+----+----------+--------+
| id | fname    | 校长   |
+----+----------+--------+
|  5 | 20190611 | RW3    |
+----+----------+--------+
1 row in set (0.00 sec)