SQL Server and English-based sql servers have Sunday as the first day of week.
Our Navision day of week is based off of Monday.
but you can set the first workday in SQL Server quite easily by setting the DATEFIRST statement
try this:
http://msdn.microsoft.com/en-us/library/ms187766(SQL.90).aspx
No comments:
Post a Comment