Monday, 19 January 2015

Get data in current week

Get  data for the current week in TSQL

The below is how to get the sum of something for a week

select sum(somthing) from atable  WHERE your_date  >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) / 7 * 7, 0)
AND  your_date  <= DATEADD(DAY, DATEDIFF(DAY, -1, GETDATE()), 0)






You could also use

select* from atable  WHERE your_date  >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) / 7 * 7, 0)
AND  your_date  <= DATEADD(DAY, DATEDIFF(DAY, -1, GETDATE()), 0)


to get all data for that week

No comments:

Post a Comment

Chrome 138 the last supported

Chrome 138 the last supported  Hey Everyone, Chrome 138 is the last version of Chrome that will support Android 8.0 (Oreo) and Android 9.0 (...