我如何将日期部分(dayday,datediff(day,0,Date)/ 7 * 7)/ 7 + 1 AS WeekNumOverall转换为U-sql
问题描述:
我想在u-sql中设置星期编号并想将下面的代码转换为u -sql我如何将日期部分(dayday,datediff(day,0,Date)/ 7 * 7)/ 7 + 1 AS WeekNumOverall转换为U-sql
Datepart(day, datediff(day, 0, Date)/7 * 7)/7 + 1 AS WeekNumOverall,
我该怎么做?
答
在U-SQL中,您可以使用.NET DateTime属性和方法。您可以使用DateTime.DayOfYear(请参阅DateTime Properties),而不是DATEPART。类似于:
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);
如果您只需查看此预先计算的日期维度,是否更好?从您喜欢的数据仓库导入一个。 – wBob