mysql日期操作

iteye_21199

于 2012-03-21 17:55:00 发布

阅读量63

点赞数

文章标签：数据库

mysql 昨天的函数

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 count(*),date_sub(curdate(),interval 1 day) from player p where date(p.createDate)= date_sub(curdate(),interval 1 day) and date(p.loginDate) >date(p.createDate);