sql语句如下:

select top 10 * from table WHERE CONVERT(VARCHAR,addDate,120) LIKE '2012-12-10%'