我希望用这样的日期显示星期几 Fulltime FulltimeTicket_Value Contract Casual 星期六,2018/06/09 1 500 2 3 星期四,2018/06/07/2 2 1000 1 4 星期三,2018/06/06 0 0 0 0 星期五,2018/06/08 3 1500 2 2 星期二,2018/06/05 1 500 4 1 我尝试过:
I want to display days of the week with the date like this Fulltime FulltimeTicket_Value Contract Casual Saturday, 2018/06/09 1 500 2 3 Thursday, 2018/06/07 2 1000 1 4 Wednesday, 2018/06/06 0 0 0 0 Friday, 2018/06/08 3 1500 2 2 Tuesday, 2018/06/05 1 500 4 1 What I have tried:
SELECT Date_to_Display = CAST(Time AS DATE) ,Fulltime = SUM(CASE WHEN jobtype = 'fulltime' THEN 1 ELSE 0 END) ,FulltimeTicket_Value=SUM(CASE WHEN jobtype='fulltime' THEN 1 ELSE 0 END)* MAX(CASE WHEN jobtype='fulltime' THEN Vale ELSE 0 END) ,Contract = SUM(CASE WHEN jobtype = 'contract' THEN 1 ELSE 0 END) ,Casual = SUM(CASE WHEN jobtype = 'casual' THEN 1 ELSE 0 END) FROM CanLog AS clog WHERE Time >= '2018-02-12' and time < '2018-02-15' GROUP BY CAST(Time AS DATE) ORDER BY CAST(Time AS DATE);推荐答案
您可以使用SQL DATENAME函数来获取星期几。这是一个例子。 You can use SQL DATENAME function to get the day of the week. Here is an example. DECLARE @temp TABLE (Id INT Identity(1,1), SomeDate Date) INSERT INTO @temp SELECT '2018/06/09' UNION SELECT '2018/06/07' SELECT DATENAME(dw,SomeDate) +', ' + CONVERT(VARCHAR(10),SomeDate) 'Date_to_Display' FROM @temp
输出: Date_to_Display 周六,2018-06-09 周四,2018-06-07
Output: Date_to_Display Saturday, 2018-06-09 Thursday, 2018-06-07
更多推荐
显示一周中的几天
发布评论