You are here: Home > Technical Articles > MS SQL Server - Function Day of Week

MS Sql Server - Function Day of Week

Sql Script for function which returns day of week.

CREATE FUNCTION dbo.f_day_of_week
(
        @dtDate DATETIME 
)

RETURNS VARCHAR(10)
AS
BEGIN

    DECLARE @strDayofWeek VARCHAR(10)
   
    SELECT @strDayofWeek = CASE DATEPART(weekday,@dtDate)
                    WHEN 1 THEN 'Sunday'
                    WHEN 2 THEN 'Monday'
                    WHEN 3 THEN 'Tuesday'
                    WHEN 4 THEN 'Wednesday'
                    WHEN 5 THEN 'Thursday'
                    WHEN 6 THEN 'Friday'
                    WHEN 7 THEN 'Saturday'
        END
    RETURN (@strDayofWeek)

END
GO


Published On: 02 Aug 2009