DECLARE @Dt DATETIME SET @Dt='2014-10-20' SELECT * FROM table1 AS a WHERE NOT EXISTS ( SELECT 1 FROM table1 WHERE stuNAme = a.stuNAme AND createTime < a.createTime ) AND createTime>=@Dt AND createTime<@Dt+1
datediff(dd,createTime,'2014-10-20')=0
select * from 表 where ( SELECT CONVERT(varchar(11), createTime, 120))='2014-10-20'
datediff(dd,createTime,'2014-10-20')=0
datediff(dd,createTime,'2014-10-20')=0
select * from table1 where CONVERT(VARCHAR(10),createTime,23)=‘2014-10-20’
select * from table1 where createTime between '2014-10-20 00:00:00' and '2014-10-20 23:59:59'楼主能不能说说为什么不要用你说的方法
不过datetime 是有毫秒的,应该写成
-- @queryDate 为 datetime 类型,值为无时间的 2014-10-20
createTime>=@queryDate and createTime<DateAdd(day,1,@queryDate)
SET @Dt='2014-10-20'
SELECT *
FROM table1 AS a
WHERE NOT EXISTS ( SELECT 1
FROM table1
WHERE stuNAme = a.stuNAme
AND createTime < a.createTime )
AND createTime>=@Dt AND createTime<@Dt+1