Get todays Day Name SQL server

Category > MSSQLSERVER || Published on : Friday, August 1, 2014 || Views: 7968 || how to get todays date in sql how to get todays date in sql server get today's date in sql server sql get today at midnight sql get today date without time sql get current day sql get current day of week sysdate in sql server


There are functions which already provided by SQL. We will use these function to achieve our expected result.

To get todays day name using system datetime ,we can use following query.

 

 

	SELECT DATENAME(DW,GETDATE()) DayName

It will take today's date-time and will return the day name in this way you can get todays day name.

 

Download Source Codes