pmod(datediff(substr(a_birth_time,1,10),
'2010-01-03'
),7)
in
(6,0)
then
'周末'
else
'周中'
end
as
date_type
根据日期判断星期几
最新推荐文章于 2024-07-17 14:58:37 发布
pmod(datediff(substr(a_birth_time,1,10),
'2010-01-03'
),7)
in
(6,0)
then
'周末'
else
'周中'
end
as
date_type