日期转换函数
CONVERT(date,start_date,111) >= CONVERT(date,CAST('" + query.getStartDate() + "' as date),111)
指定顺序排序函数
ORDER BY CHARINDEX(RTRIM(CAST(status AS CHAR)), '1,3,6,0,4,2,5,6,7,8,9,10,11,12')
日期转换函数
CONVERT(date,start_date,111) >= CONVERT(date,CAST('" + query.getStartDate() + "' as date),111)
指定顺序排序函数
ORDER BY CHARINDEX(RTRIM(CAST(status AS CHAR)), '1,3,6,0,4,2,5,6,7,8,9,10,11,12')