11/2/2023 0 Comments Sql server day of week![]() ![]() We can aswell use FORMAT function which is introduced in Sql Server 2012 to get Day/Weekday name from Date in Sql Server. SELECT GetDate() 'Today', DATENAME(dw,GETDATE()) 'Day Name' SELECT GETDATE() 'Today', DATENAME(weekday,GETDATE()) 'Day Name' We can use DATENAME() function to get Day/Weekday name from Date in Sql Server, here we need specify datepart parameter of the DATENAME function as weekday or dw both will return the same result. In this article we will see how we can get Day/Weekday name from Date in Sql Server. Many a times we come across a scenario where we may need to get Day/Weekday name from Date in Sql Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |