参考网址:http://www.w3school.com.cn/sql/sql_dates.asp。
1 CONVERT(char(10), PassedDate, 120), 2 DATEADD(day, DATEDIFF(day, 0, PassedDate), 0)
参考网址:http://www.w3school.com.cn/sql/sql_dates.asp。
1 CONVERT(char(10), PassedDate, 120), 2 DATEADD(day, DATEDIFF(day, 0, PassedDate), 0)