SELECT ((DatePart(weekday, getdate()) + @@DATEFIRST-1) % 7)-- 0 = Sunday/Dimanche-- ...-- 6 = Saturday/Samedi-- SELECT DateName(weekday , getDate()) -- ! language/localisation