急！急！急！请教：在SQLserver中有个datetime类型的字段，我想查某一天某个时间的记录，SQL该怎么写？？？

[ssd]

用下列语句查不到
select * from table1 where StartTime='2002-2-2 12:09:00'

[希偌]

select * from table1 where StartTime='#2002-2-2 12:09:00#'

[tjdiy]

把2002-2-2 12:09:00改成#2002/2/2 12:09:00#试试
还不行就这样
starttime="#2002/2/2 12:09:00#"
starttime=cdate(starttime)
sql="select * from table1 where StartTime=' & starttime & "'"