显示一周中的几天 [英] Displaying days of the week

问题描述

我希望用这样的日期显示星期几





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

这篇关于显示一周中的几天的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！