如何将Datepart(day，datediff(day，0，Date) /7* 7) /7+1 AS WeekNumOverall转换为U-sql

Question

我想在u-sql的周数，并希望转换为u-sql以下代码。

Datepart(day, datediff(day, 0, Date) / 7 * 7) / 7 + 1 AS WeekNumOverall,

我该怎么做呢？

Answer 1

在U-SQL中，您可以使用.NET DateTime属性和方法。您可以使用DateTime.DayOfYear代替DATEPART (参见DateTime Properties。类似于：

SELECT Date.DayOfYear / 7 + 1 AS WeekNumOverall FROM 
(VALUES (new DateTime(2017,1,1)) , (new DateTime(2017,3,1)) , (new DateTime(2017,10,12))) AS vt(Date);