SQL Query to Find the day name of 2021 new year day from Sysdate?
How to Find the day name of the 2021 new year day from the system?
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;