In my posts
table, it saves timestamp for each post record.
What query can group posts by day, using this timestamp column?
See Question&Answers more detail:osIn my posts
table, it saves timestamp for each post record.
What query can group posts by day, using this timestamp column?
See Question&Answers more detail:osHow about this? Using the DATE
function:
SELECT DATE(FROM_UNIXTIME(MyTimestamp)) AS ForDate,
COUNT(*) AS NumPosts
FROM MyPostsTable
GROUP BY DATE(FROM_UNIXTIME(MyTimestamp))
ORDER BY ForDate
This will show you the number of posts on each date that the table has data for.