Group by day week or month » History » Revision 2
Revision 1 (Viacheslav Anzhiganov, 04/05/2025 03:43 PM) → Revision 2/3 (Viacheslav Anzhiganov, 04/05/2025 03:43 PM)
# Group by day week or month
Origin: http://ben.goodacre.name/
Sum counts of an occurrence into days, weeks, or months
## Group by day
```sql
SELECT date_trunc('day', loggedin) AS "Day" , count(*) AS "No. of users"
FROM logins
WHERE created > now() - interval '3 months'
GROUP BY 1
ORDER BY 1;
```
## Group by week
```sql
SELECT date_trunc('week', loggedin) AS "Week" , count(*) AS "No. of users"
FROM logins
WHERE created > now() - interval '3 months'
GROUP BY 1
ORDER BY 1;
```
## Group by month
```sql
SELECT date_trunc('month', loggedin) AS "Month" , count(*) AS "No. of users"
FROM logins
WHERE created > now() - interval '1 year'
GROUP BY 1
ORDER BY 1;
```