The First Day of the Week

Question

The First Day of the Week

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
July 8, 2024 at 12:00 am

#4423846

Comments posted to this topic are about the item The First Day of the Week

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

Be REALLY careful here folks. The answer and the reason is correct except for one of the most important places in SQL Server and that's for the DATEDIFF() function. The value of DATEFIRST does NOT change the first day of the week for DATEDIFF(week, SomeDateTime). Instead, the first day of the week is always considered to be SUNDAY for DATEDIFF(week).

See the article subsection that speaks about this at the following link...

https://learn.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql#remarks

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)