DB NAME : testDB
column's NAME : createDate
real data : 2009-02-07 15:15:43.000
compare
select * from testDB where cast(convert(char(10),createDate,101)as datetime) >= cast(convert(char(10),'2009-02-05',101) as datetime)
Saturday, 28 March 2009
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment