27,581
社区成员




CREATE TABLE TB
(日期 DATE)
ALTER TABLE TB ADD 星期 AS CASE WHEN DATEPART(WEEKDAY,日期)=1 THEN '星期日'
WHEN DATEPART(WEEKDAY,日期)=2 THEN '星期一'
WHEN DATEPART(WEEKDAY,日期)=3 THEN '星期二'
WHEN DATEPART(WEEKDAY,日期)=4 THEN '星期三'
WHEN DATEPART(WEEKDAY,日期)=5 THEN '星期四'
WHEN DATEPART(WEEKDAY,日期)=6 THEN '星期五'
WHEN DATEPART(WEEKDAY,日期)=7 THEN '星期六' END
INSERT INTO TB
SELECT '2020-04-03'
[/quote]
多谢大神!完美解决!祝一生平安喜乐~
CREATE TABLE TB
(日期 DATE)
ALTER TABLE TB ADD 星期 AS CASE WHEN DATEPART(WEEKDAY,日期)=1 THEN '星期日'
WHEN DATEPART(WEEKDAY,日期)=2 THEN '星期一'
WHEN DATEPART(WEEKDAY,日期)=3 THEN '星期二'
WHEN DATEPART(WEEKDAY,日期)=4 THEN '星期三'
WHEN DATEPART(WEEKDAY,日期)=5 THEN '星期四'
WHEN DATEPART(WEEKDAY,日期)=6 THEN '星期五'
WHEN DATEPART(WEEKDAY,日期)=7 THEN '星期六' END
INSERT INTO TB
SELECT '2020-04-03'