将日期转换为日

Question

我正在使用SQL Server，有人可以告诉我如何写一个查询来显示一周中有人被雇用的哪一天。谁能给我举个richard wiley管理员的例子。根据消息，他是星期五被录用的。

CREATE TABLE STAFF (
sID int PRIMARY KEY,
FirstN varchar(50) NOT NULL,
LastN varchar(50) NOT NULL,
Title varchar(50) NOT NULL,
DateHired date NOT NULL,
);
INSERT INTO STAFF VALUES (5, 'Richard', 'Wiley', 'Admin', '2020-02-12')

谢谢!

Answer 1

有多种方法可以得到这个

-- Using Datename function
SELECT DATENAME(WEEKDAY,DateHired) AS day_name from dbo.STAFF where sid = 5;
GO
-- Using Format function
SELECT FORMAT(DateHired,'dddd') AS day_name from dbo.STAFF where sid = 5;
GO
--Another approach is set first day as Monday for the session and get the value
SET DATEFIRST 1 -- Setting datefirst as monday
SELECT 
CASE DATEPART(dw,DateHired) 
WHEN 1 THEN 'Monday'
WHEN 2 THEN 'Tuesday'
WHEN 3 THEN 'Wednesday'
WHEN 4 THEN 'Thursday'
WHEN 5 THEN 'Friday'
WHEN 6 THEN 'Saturday'
WHEN 7 THEN 'Sunday' end AS day_name from dbo.STAFF where sid = 5;
GO

tbody> <<tr>周三

day_name