Jul 27, 2020 12:14 pm
How to Find the day name of the 2021 new year day from the system?
2 Replies
Jul 30, 2020 2:34 pm
Hi you can use the DAY NAME function to get the day name of the new year 2021
Query:
SELECT DAYNAME("2021-01-01 12:01:01");
You will get the output as Friday.
Oct 01, 2020 2:32 pm
Select to_char(to_date('01-01-2020','DD-MM-YYYY'),'DAY') AS DAY from dual;
Leave a reply
