Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*) AS total_days
- FROM (SELECT DATE '2008-8-26' + generate_series(0, (DATE '2008-9-1' - DATE '2008-8-26')) AS all_days) AS calendar
- WHERE EXTRACT(isodow FROM all_days) < 6;
- -- based on http://pastebin.com/m4c143e84
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement