@@DATEFIRST in SQL

The @@DATEFIRST in SQL Server is one of the Date and Time Function, which will return the first day of the week. This value is between 1 and 7. If your default language is US English, then by default, 7 is returned. The basic syntax of SQL Server @@DATEFIRST is @@DATEFIRST @@DATEFIRST in SQL Example In this … Read more

SQL DATEFIRST

The SQL DATEFIRST Set Function will set the first Day of the week from 1 through 7. If your default language is Us English, then by default 7 (Sunday) is set as the first Day. The basic syntax of the DATEFIRST in SQL Server is SET DATEFIRST { number (or number_variable) } — For example, … Read more