Get day name from a date in sql server

Sometimes one would want to know the weekday name of a certain date. so here is a quick function that can do all the work, all that you need to do is to pass the date.


CREATE FUNCTION dbo.getWeekDayName
(@datename DATETIME)
RETURNS VARCHAR(25)
AS
BEGIN
DECLARE @weekdatename VARCHAR(50);
SELECT @weekdatename = DATENAME(dw , @datename)

RETURN @weekdatename

END

how to use the function

select dbo.getWeekDayName('20121215')