建一个表,内容如下
想要的效果
实现代码
SELECT
NowDay,
CASE WHEN DATEDIFF(NowDay, '1922-01-01' ) % 7 + 1=7 THEN 1
WHEN DATEDIFF(NowDay, '1922-01-01' ) % 7 + 1=1 THEN 1
ELSE 0
END AS isWeek
FROM
表名
建一个表,内容如下
想要的效果
实现代码
SELECT
NowDay,
CASE WHEN DATEDIFF(NowDay, '1922-01-01' ) % 7 + 1=7 THEN 1
WHEN DATEDIFF(NowDay, '1922-01-01' ) % 7 + 1=1 THEN 1
ELSE 0
END AS isWeek
FROM
表名