Saturday 28 March 2009

[SQL] compaire data type

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)