请大侠帮忙看看这句有错误吗?代码如下:
SELECT * FROM test where beginTime='2009-12-20 00:00:00' and endTime='2009-12-20 23:59:59'
为什么我执行了这句,却没有结果呢?
表的结构如下:
id number phone beginTime endtime
1 5 4342 2009-12-20 22:09:17 2009-12-20 22:09:23
2 23 4543 2009-12-20 22:09:28 2009-12-20 22:09:34
3 56 86675 2009-12-20 22:10:39 2009-12-20 22:11:52
SELECT * FROM test where beginTime='2009-12-20 00:00:00' and endTime='2009-12-20 23:59:59'
为什么我执行了这句,却没有结果呢?
表的结构如下:
id number phone beginTime endtime
1 5 4342 2009-12-20 22:09:17 2009-12-20 22:09:23
2 23 4543 2009-12-20 22:09:28 2009-12-20 22:09:34
3 56 86675 2009-12-20 22:10:39 2009-12-20 22:11:52
解决方案 »
- 救命啊 就2个PB的问题~~~~~~
- 局域网内程序无法连接上winserver2003的sql2000,但winserver2003本机可以连接
- 求一SQL语句
- 分栏显示并排序且加小计与合计,请各位帮忙
- 救命啊,为何@@cursor_rows返回0的?
- 请教一条更新语句!
- SQL高手看过来
- 一个表有A,B,C,D 四个字段(都位数值类型) 其中D字段的值 =A字段的值 + B字段的值 - C字段的值 ;在插入/修改记录时我应怎么处理D字段的值
- 用sql实现一个思路 ---在线期求!!!!
- 装sqlserver2000时提示挂起,重起后还是不行
- SQL SERVER 批量修改数据
- [急][急][急][急][急]请高手帮助。。。SQL遍历?
beginTime>='2009-12-20 00:00:00' and endTime<='2009-12-20 23:59:59'
其他数据库开发 MySQL/Postgresql
where beginTime >= '2009-12-20 00:00:00' and endTime <= '2009-12-20 23:59:59'SELECT * FROM test
where beginTime between '2009-12-20 00:00:00' and '2009-12-20 23:59:59'SELECT * FROM test
where datediff(dd , beginTime , '2009-12-20') = 0
楼主想要这个结果吧:SELECT *
FROM test
where convert(varchar,beginTime,111)>='2009/12/20'
and convert(varchar,endTime,111) <='2009/12/20'
用between and 连接BeginTime 和 EndTime