Pages

Saturday, September 21, 2013

SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage | Journey to SQL Authority with Pinal Dave

The master database's syslanguages table has a DateFirst column that defines the first day of the week for a particular language. SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day as first day of the week using SET DATEFIRST 5 This will… Continue Reading...

Source: SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage | Journey to SQL Authority with Pinal Dave