级联DATEADD & DATEPART

Question

Server 2008。是否有方法连接下面的内容并删除00:00:00:000

*编辑-完整日期列包含日期列表

SELECT DISTINCT
    DATEADD(dd, -(DATEPART(dw, fulldate)-1), fulldate) [WeekStart], 
    DATEADD(dd, 7-    (DATEPART(dw, fulldate)), fulldate) [WeekEnd]
FROM time
WHERE YEAR(time) >= 2016
ORDER BY WeekStart

结果：

WeekOf

12-27-2015-01-02-2016

等等..。

Answer 1

由于dateadd返回date而不是string --您必须首先使用适当的格式化 (在您的示例中为110)将值转换为字符串，然后将它们连接起来：

select distinct
    convert(nvarchar(20), DATEADD(dd, -(DATEPART(dw, fulldate)-1), fulldate), 110) + '-' + 
    convert(nvarchar(20), DATEADD(dd, 7-    (DATEPART(dw, fulldate)), fulldate), 110) as WeekOf
from time
where YEAR(time) >= 2016
order by WeekStart