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
Subscribe to:
Post Comments (Atom)
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 (...
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
-
Do you charge your device in a public or on a non secure work space ? if the answer is yes then you are leaving your device open to be hac...
No comments:
Post a Comment