How to set monday as first day of week in SQL Server

by

The first day of the week is based on your language settings of the server. The default setting for us_english is 7 (Sunday)

You can find the current first day of the week by using SELECT @@DATEFIRST

However, you can use DATEFIRST for this. Just put it at the top of your query

SET DATEFIRST 1; this sets Monday to the first day of the week for the current connection.

http://technet.microsoft.com/en-us/library/ms181598.aspx

More Related Contents:

  1. Using merge..output to get mapping between source.id and target.id
  2. SQL Server, How to set auto increment after creating a table without data loss?
  3. How can I truncate a datetime in SQL Server?
  4. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  5. How to add Active Directory user group as login in SQL Server
  6. Why use the INCLUDE clause when creating an index?
  7. SqlServer: Login failed for user
  8. How to set a default value for an existing column
  9. An attempt was made to access a socket in a way forbidden by its access permissions
  10. SQL Server Query: Fast with Literal but Slow with Variable
  11. How do I find a stored procedure containing ?
  12. Should every User Table have a Clustered Index?
  13. An attempt to login using SQL authentication failed
  14. SQL Server, the misleading XLOCK & optimizations
  15. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  16. How to find SQL Server running port?
  17. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  18. Changing SQL Server collation to case insensitive from case sensitive?
  19. Sort Bullets in Database
  20. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  21. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  22. Database design: Calculating the Account Balance
  23. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  24. INFORMATION_SCHEMA vs sysobjects
  25. Merge multiple rows into a single row
  26. “Prevent saving changes that require the table to be re-created” negative effects
  27. How to change column datatype in SQL Server database without losing data?
  28. Table Valued Function Killing My Query Performance
  29. How to convert text column to datetime in SQL
  30. How to choose the clustered index in SQL Server?

Leave a Comment