In
this article I am going to explain how to get week day name in Sql server query.
In
the previous article I have explained how to Get week day name and month nameof current date, Move selected item or all items from one checkboxlist toanother and Get the URL (address) of current page code behind.
Description:
Some
time we need to get week day name from date.
Implementation:
We
can get the week day name using Datename
function of Sql server.
Example:
Select [Current date]=getdate(),[Current
week day name]= datename(dw,getdate())
0 Comments