# Counting posts per day

**URL:** <https://forum.kirupa.com/t/counting-posts-per-day/282224>\
**Category:** Uncategorized\
**Created:** [February 19, 2009, 5:01am UTC](https://forum.kirupa.com/t/counting-posts-per-day/282224 "2009-02-19T05:01:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![NeoDreamer](https://avatars.discourse-cdn.com/v4/letter/n/ccd318/32.png) [@NeoDreamer](https://forum.kirupa.com/u/NeoDreamer)\
**Post date:** [February 19, 2009, 5:01am UTC](https://forum.kirupa.com/t/counting-posts-per-day/282224/1 "2009-02-19T05:01:00Z")

</div>

My table stores the Unix timestamp of each forum post. I want to be able to graph [number of posts in this day] VS [days since epoch]. My first step was to be able to detect which posts were from the same day:

```auto

SELECT ROUND(time / 86400) as daysSinceEpoch, time
FROM posts 
ORDER BY daysSinceEpoch
ASC

```

This gives me:

```auto

daysEpoch time
13378 1155850620
13378 1155850620
13378 1155850920
13378 1155851040
13378 1155851160
13386 1156568400
13387 1156629120
13387 1156629180
13387 1156629180

```

Now I don’t know how to complete the query to give me:

```auto

daysEpoch numPostsInThisDay
13378 5
13386 1
13387 3

```