[原创]直接在数据库中根据日期取出该日的星期

SELECT PASS_YUKO_DT,
CASE
WHEN TO_CHAR(TO_DATE(PASS_YUKO_DT,'YYYY-MM-DD'),'D') = '1' THEN 'SUNDAY'
WHEN TO_CHAR(TO_DATE(PASS_YUKO_DT,'YYYY-MM-DD'),'D') = '2' THEN 'MONDAY' 
WHEN TO_CHAR(TO_DATE(PASS_YUKO_DT,'YYYY-MM-DD'),'D') = '3' THEN 'TUESDAY'
WHEN TO_CHAR(TO_DATE(PASS_YUKO_DT,'YYYY-MM-DD'),'D') = '4' THEN 'WEDNESDAY'
WHEN TO_CHAR(TO_DATE(PASS_YUKO_DT,'YYYY-MM-DD'),'D') = '5' THEN 'THURSDAY'
WHEN TO_CHAR(TO_DATE(PASS_YUKO_DT,'YYYY-MM-DD'),'D') = '6' THEN 'FRIDAY'
WHEN TO_CHAR(TO_DATE(PASS_YUKO_DT,'YYYY-MM-DD'),'D') = '7' THEN 'SATURDAY'
END AS YOHBI_NM
FROM HSUSERID

效果如下图：