Forum

SQL Query to Find t...
 
Share:
Notifications
Clear all

SQL Query to Find the day name of 2021 new year day from Sysdate?

3 Posts
2 Users
0 Likes
1,334 Views
KV Kumar
Posts: 27
Admin
Topic starter
(@vinodkrsetty)
Eminent Member
Joined: 3 years ago

How to Find the day name of the 2021 new year day from the system?

2 Replies
Gangadhar Rao
Posts: 47
 Gangadhar Rao
Guest
(@Gangadhar Rao)
Eminent Member
Joined: 2 years ago

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. 

Reply
Mahesh Karpe
Posts: 1
 Mahesh Karpe
Guest
(@Mahesh Karpe)
New Member
Joined: 2 years ago

Select to_char(to_date('01-01-2020','DD-MM-YYYY'),'DAY') AS DAY from dual;

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: