Today i will tell you how to retrieve day from date using sql.
In the Previous articles i explained how to retrieve logged in user email in asp.net, where to place google analytics tracking code, how to retrieve day from date using C#.net, how to retrieve month from date in c#.net, how to retrieve year from date in c#.net and many more about Sql.
Today or in future you will have to get day from date using sql.
SELECT Day('2/4/2014') AS [date_day]
Here what we are doing is getting day from current date of server.
Suppose you want to get date from table then use below query.
SELECT Day(date_column) AS [date_day] FROM Table_name