select top 1* from sd_user where CONVERT(nvarchar(10),addtime,120)='2012-08-31'
把addtime字段转化成nvarcahr类型，就能判断了
