MySql取昨天时间
发布网友
共6个回答
热心网友
select * from 表名 where diffdate('d',current_date,date())=1'查找数据库字段current_date记录到现在的时间date()等于一的也就是昨天的记录
热心网友
SELECT
DATE_SUB(current_date，INTERVAL
1
DAY);
SELECT
DATE_SUB(curdate(),
INTERVAL
1
DAY);
mysql>
select
date_sub(curdate(),interval
1
day);
+------------------------------------+
|
date_sub(curdate(),interval
1
day)
|
+------------------------------------+
|
2006-06-19
|
+------------------------------------+
1
row
in
set
(0.09
sec)
mysql>
select
date_sub('2006-06-04',interval
1
day);
+---------------------------------------+
|
date_sub('2006-06-04',interval
1
day)
|
+---------------------------------------+
|
2006-06-03
|
+---------------------------------------+
1
row
in
set
(0.00
sec)
热心网友
SELECT DATE_SUB(curdate(), INTERVAL 1 DAY);
或者
SELECT curdate() - INTERVAL 1 DAY;
热心网友
SELECT DATE_SUB(current_date，INTERVAL 1 DAY);
SELECT DATE_SUB(curdate(), INTERVAL 1 DAY);
mysql> select date_sub(curdate(),interval 1 day);
+------------------------------------+
| date_sub(curdate(),interval 1 day) |
+------------------------------------+
| 2006-06-19 |
+------------------------------------+
1 row in set (0.09 sec)
mysql> select date_sub('2006-06-04',interval 1 day);
+---------------------------------------+
| date_sub('2006-06-04',interval 1 day) |
+---------------------------------------+
| 2006-06-03 |
+---------------------------------------+
1 row in set (0.00 sec)
热心网友
日期 = curdate()-1 哈哈
热心网友
curdate()-1
