Get todays Day Name SQL server

3 Comments | 4063 Views | Post by: Admin | 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.


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:

loading...