[Original] Directly take the date of the day according to the date of the database

SELECT Pass_yuko_dt, casser (TO_DATE (PASS_YUKO_DT, 'YYYY-MM-DD'), 'D') = '1' TEN 'SUNDAY' WHEN TO_CHAR (TO_DATE (PASS_YUKO_DT, 'YYYY-MM-DD'), 'D ') =' 2 'TEN' MONDAY 'WHEN TO_CHAR (TO_DATE (PASS_YUKO_DT,' YYYY-MM-DD '),' D ') =' 3 'TEN' TUESDAY 'WHEN TO_CHAR (TO_DATE (PASS_YUKO_DT,' YYYY-MM- DD '),' D ') =' 4 'TEN' WEDNESDAY 'WHEN TO_CHAR (TO_DATE (PASS_YUKO_DT,' YYYY-MM-DD '),' D ') =' 5 'TEN' 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' Ten 'Saturday' End as yohbi_nm from hsuserid

The effect is as follows: