Find the day name of 2021 new year day from sysdate?
how to Find the day name of 2021 new year day from sysdate?
Hi you can use the DAY NAME function to get the day name of the new year 2021
SELECT DAYNAME("2021-01-01 12:01:01");
You will get the output as Friday.
Select to_char(to_date('01-01-2020','DD-MM-YYYY'),'DAY') AS DAY from dual;