in reply to sql datetime value with today
I'm not sure but it may be better / easier / faster / simpler to do the comparison in the SQL:
Something like http://sqlfiddle.com/#!3/d2910/8/2
-- fiddle schema (LHS): create table t( d date ); -- fiddle SQL (RHS): insert into t values ( getdate() ) , ( getdate() + 1 ) ; -- t now contains 2 rows select * from t where d = cast(getdate() as date); -- returns only the one row
(Note that you have to cast the value as getdate returns a timestamp and not a date)
|
|---|