id name datatime
1 aaa 2009-02-10 16:35:31
2 bbb 2009-02-11 16:36:34
3 ccc 2009-02-12 16:32:32
......
n nnn 2010-04-10 16:41:37如何获取datatime为“2009-02-10 16:35:31”到“2009-04-15 16:32:45”之间的数据
1 aaa 2009-02-10 16:35:31
2 bbb 2009-02-11 16:36:34
3 ccc 2009-02-12 16:32:32
......
n nnn 2010-04-10 16:41:37如何获取datatime为“2009-02-10 16:35:31”到“2009-04-15 16:32:45”之间的数据
select * from tb whre datatime between '2009-02-10 16:35:31' and '2009-04-15 16:32:45'
select * from 表 where datatime >= '2009-02-10 16:35:31' and datatime <= '2009-04-15 16:32:45'或select * from 表 where datatime between '2009-02-10 16:35:31' and '2009-04-15 16:32:45'
select * from tb where datatime between '2009-02-10 16:35:31' and '2009-04-15 16:32:45'