Created
March 9, 2015 22:36
-
-
Save prestonp/4f249bf23a273759afec to your computer and use it in GitHub Desktop.
grab iso weeks from month
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select extract(week from n) from generate_series('2015-02-01'::timestamp, '2015-02-28', '1 week') n; |
Author
prestonp
commented
Mar 9, 2015
select sum(total), extract(week from datetime)
from orders
where
extract(week from datetime) in (select extract(week from n) from generate_series('2015-02-01'::timestamp, '2015-02-28', '1 week') n)
and status = 'accepted'
group by extract(week from datetime)
order by extract(week from datetime);
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment