postgreSQL SELECT the last day of month
You can select the last day of month.
201608 is replaceable with a variable.
Count the number of records per week
SELECT date_trunc('week', <>) AS "Week" , count(*) FROM <> GROUP BY 1 ORDER BY 1;
In this page (written and validated by A. Gawali) you learned about postgreSQL SELECT the last day of month . What's Next? If you are interested in completing postgreSQL tutorial, your next topic will be learning about: postgreSQL Event Triggers.