I have two fields EnterRecovery DateTime and ExitRecovery DateTime. I need to filter a query where these fields have 00:00:00 for the time portion. They will always have the date portion. Some of my records have times in them, others don't.

Can I just use some like

declare @ttRecoveryBetween datetime
set @ttRecoveryFrom = '10/01/2002 00:00:00'

select * from meetings 
where EnterRecovery between @ttRecoveryBetween and @ttRecoveryBetween

Thanks
Kirk