How to get Day or Weekday name from date in Sql Server


How to get Day or Weekday name from date in Sql Server



To Get Day or weekday from date we need to run below query




    SELECT GETDATE() 'Today', DATENAME(weekday,GETDATE()) ' DayName '



The Result will be like;


       Today                                  DayName 
       2020-05-14 13:14:23.503 Thursday

No comments:

Post a Comment