a
id zj_time1 2010-07-06
2 2010-07-05
3 2010-07-04
4 2010-07-07
SELECT * FROM `a` WHERE zj_time>='2010-07-05' and zj_time<='2010-07-11'上面语句不对
高手帮忙一下谢谢结果是id zj_time1 2010-07-06
2 2010-07-05
4 2010-07-07
id zj_time1 2010-07-06
2 2010-07-05
3 2010-07-04
4 2010-07-07
SELECT * FROM `a` WHERE zj_time>='2010-07-05' and zj_time<='2010-07-11'上面语句不对
高手帮忙一下谢谢结果是id zj_time1 2010-07-06
2 2010-07-05
4 2010-07-07
试试这个,能不能得到你要的结果。
mysql> select * from a2 where zj_time>=str_to_date('2010-07-05', '%Y-%m-%d') and zj_time<=str_to_date('2010-07-11', '%Y-%m-%d');有兴趣可以检查一下你所用的日期的格式:
mysql> show variables like '%format%';
+---------------------+-------------------+
| Variable_name | Value |
+---------------------+-------------------+
| binlog_format | STATEMENT |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| time_format | %H:%i:%s |
+---------------------+-------------------+
5 rows in set (0.00 sec)