Get todays Day Name SQL server

  MSSQLSERVER   Friday, August 1, 2014   5676 | 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.




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