显示一周中的几天

本文介绍了显示一周中的几天的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我希望用这样的日期显示星期几 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