Question

sql server 2008查询时报错：从字符串转换日期和/或时间时，转换失败。脚本如下

select y.d,y.sxrq from (select d as d,(CAST(YEAR(rq) as varchar(4))+'-'+case when month(rq)<10 then '0'+CAST(month(rq) as varchar(1)) else CAST(month(rq) as varchar(2)) end +'-'+case when day(rq)<10 then '0'+CAST(month(rq) as varchar(1)) else CAST(day(rq) as varchar(2)) end) as sxrq from (select ll as d,rtrim(isnull(rq,'')) as rq from ceshi t where isdate(t.rq)=1 and t.rq like '%-%' ) s ) y where y.sxrq>CONVERT(varchar(10),GETDATE(),23)表结构和表的数据请查看截图可以确认是由于存在rq字段存在数据2019-21-3 导致的，请问如果在没有删除该行数据的情况下脚本该怎样写？





Answer 1

starttime.ToShortDateString()试试这个函数strattime是datetime类型的变量