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 1201");
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
Forum Statistics
8
Forums
116
Topics
249
Posts
1
Online
2,199
Members
Latest Post: Write a query to display the first and the last record from the Employee info table. Our newest member: Angus Shellshear Recent Posts Unread Posts
