sql语句如下: select top 10 * from table WHERE CONVERT(VARCHAR,addDate,120) LIKE '2012-12-10%' 【文章转自阿里云代理商 http://www.558idc.com/aliyun.html 欢迎留下您的宝贵建议】
sql语句如下:
select top 10 * from table WHERE CONVERT(VARCHAR,addDate,120) LIKE '2012-12-10%'