select * from table1 where applytime between 当天0点 and 现在

请问当天0点 , 现在,该怎么写??

当天是哪天？假定为执行当日0点，到执行当日当时语句如下

select *
from table1
where applytime
between
(dateadd(day,datediff(day,0,getdate()),0))
and
(getdate())

[此贴子已经被作者于2006-6-6 9:19:58编辑过]

select * from table where  applytime between convert(datetime,convert(char(10),getdate(),103),103) and getdate()