Skip to toolbar

Forum

Find the day name o...
 
Notifications
Clear all

Find the day name of 2021 new year day from sysdate?  


vinodkrsetty
Posts: 15
Admin
(@vinodkrsetty)
Member
Joined: 1 year ago

how to Find the day name of 2021 new year day from sysdate?

1 Reply
Gangadhar Rao
Posts: 40
 Gangadhar Rao
Guest
(@Gangadhar Rao)
Joined: 2 months 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

Leave a reply

Author Name

Author Email

Title *

Maximum allowed file size is 10MB

 
Preview 0 Revisions Saved
Share: