KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I use DATEDIFF function to filter records added this week only: DATEDIFF(week, DateCreated, GETDATE()) = 0 and I noticed what it's assumed what week starts on Sunday. But in my case I would prefer to set start of week on Monday. Is it possible somehow in T-SQL? Thanks! Update: Below is an example showing what DATEDIFF doesn't check @@DATEFIRST variable so I need another solution. SET DATEFIRST 1; SELECT DateCreated, DATEDIFF(week, DateCreated, CAST('20090725' AS DATETIME)) AS D25, DATEDIFF(week, DateCreated, CAST('20090726' AS DATETIME)) AS D26 FROM ( SELECT CAST('20090724' AS DATETIME) AS DateCreated UNION SELECT CAST('20090725' AS DATETIME) AS DateCreated ) AS T Output: DateCreated D25 D26 ----------------------- ----------- ----------- 2009-07-24 00:00:00.000 0 1 2009-07-25 00:00:00.000 0 1 (2 row(s) affected) 26 Jul 2009 is Sunday, and I want DATEDIFF returns 0 in third column too.
Tags (comma-separated)
Save Edits
Cancel