LISTING 3: Influencing DATEPART()'s Date Components
 by Changing the DATEFIRST Session Setting

SET DATEFIRST 2
GO
SELECT ' Saturday:' AS 'DayOfWeek'
             , DATEPART(weekday, 'April 6, 2002')
                           AS 'DATEPART(weekday)'
             , DATENAME(weekday, 'April 6, 2002')
                           AS 'DATENAME(weekday)'
             , DATEPART(week, 'April 6, 2002')
                           AS 'DATEPART(week)'
             , DATENAME(week, 'April 6, 2002')
                           AS 'DATENAME(week)'
             UNION ALL
SELECT '   Sunday:'
             , DATEPART(weekday, 'April 7, 2002')
             , DATENAME(weekday, 'April 7, 2002')
             , DATEPART(week, 'April 7, 2002')
             , DATENAME(week, 'April 7, 2002')
             UNION ALL
SELECT '   Monday:'
             , DATEPART(weekday, 'April 8, 2002')
             , DATENAME(weekday, 'April 8, 2002')
             , DATEPART(week, 'April 8, 2002')
             , DATENAME(week, 'April 8, 2002')
             UNION ALL
SELECT '  Tuesday:'
             , DATEPART(weekday, 'April 9, 2002')
             , DATENAME(weekday, 'April 9, 2002')
             , DATEPART(week, 'April 9, 2002')
             , DATENAME(week, 'April 9, 2002')
GO
SET DATEFIRST 7
GO