LISTING 4: Influencing DATENAME()'s Date Components
 by Changing the LANGUAGE Session Setting

SET LANGUAGE FRENCH
GO
SELECT ' Saturday:' AS 'DayOfWeek'
             , DATEPART(month, 'Avril 6, 2002')
                           AS 'DATEPART()'
             , DATENAME(month, 'Avril 6, 2002')
                           AS 'DATENAME()'
              UNION ALL
SELECT '   Sunday:'
             , DATEPART(weekday, 'Avril 7, 2002')
             , DATENAME(weekday, 'Avril 7, 2002')
GO
SET LANGUAGE US_English
GO