select选择时间的问题 我想查询出ModiDate='2007-12-06 14:27:54' 的记录。语句: SELECT * FROM PriceRecordTable WHERE (Modidate IN ('2007-12-06 14:27:54'))但为什么找不到呢??时间的查询到底怎么样才正确呢?? modidate的字段属性为: datetime 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT * FROM PriceRecordTable WHERE Modidate ='2007-12-06 14:27:54') SELECT * FROM PriceRecordTable WHERE Modidate ='2007-12-06 14:27:54' SELECT * FROM PriceRecordTable WHERE Modidate ='2007-12-06 14:27:54' SELECT * FROM PriceRecordTable WHERE Modidate ='2007-12-06 14:27:54' SELECT * FROM PriceRecordTable WHERE Modidate = ('2007-12-06 14:27:54')用等于你的也应该可以 SELECT * FROM PriceRecordTable WHERE Modidate = '2007-12-06 14:27:54' 不得。我试过了。用 Modidate ='2007-12-06 14:27:54'也不得。是不是考虑到后面的纳秒啊??? SELECT * FROM PriceRecordTable WHERE(Modidate ='2007-12-06 14:27:54') 还是不得呢。 SELECT * FROM PriceRecordTable WHERE convert(varchar(10),Modidate,120)+' '+convert(VARCHAR(8),Modidate,114)='2007-12-06 14:27:54' 好像加了 .001到.999然后用 WHERE (Modidate >= '2007-12-06 14:01:36.001') AND (Modidate <= '2007-12-06 14:01:36.999')这样才得哦。怪事 SQL中如何调用存储过程删除目录。。里目录里面包含文件?? 大虾!快帮我看一下这一游标语句哪里错了,什么执行不了!!!快帮帮忙。谢谢了! 这句SQL错在哪里 选择不存在另一个表中的数据 SQLSERVER2000终极疑难问题 求助!如何在SQL2005中链接另一个MSDE2000?(在线等,急!) 典型数据库查询问题,数据库程序员必读! 怪问题!SQL和window2000密码问题?求救!急! 查询时间的问题 关于数据汇总的sql语句 sql2005备份还原问题 能否为数据库用户填加只读日志的权限
FROM PriceRecordTable
WHERE Modidate ='2007-12-06 14:27:54')
FROM PriceRecordTable
WHERE Modidate ='2007-12-06 14:27:54'
FROM PriceRecordTable
WHERE Modidate ='2007-12-06 14:27:54'
SELECT * FROM PriceRecordTable WHERE Modidate ='2007-12-06 14:27:54'
WHERE Modidate = ('2007-12-06 14:27:54')用等于
你的也应该可以
WHERE Modidate = '2007-12-06 14:27:54'
还是不得呢。
WHERE convert(varchar(10),Modidate,120)+' '+convert(VARCHAR(8),Modidate,114)='2007-12-06 14:27:54'
(Modidate <= '2007-12-06 14:01:36.999')
这样才得哦。怪事