Get todays Day Name SQL server

  MSSQLSERVER   Friday, August 1, 2014   4285 | 1 Comment | Not Downloaded Yet!!! | No Demo | Pawan Kumar
 Tags: 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

Post Comments

if you have some suggestion, question, request on Get todays Day Name SQL server.

Please use the comment box to express your views.

 

Comments: