Is there a reason for storing timestamps in a non-timestamp format? (Except for saving some mktime commands?)
Is there a way to use the following code with timestamps stored int(10)?
Code: Select all
SELECT YEAR(timestamp) as year, MONTH(timestamp) as month, SUM(comments) as commentcount
FROM {$serendipity['dbPrefix']}entries
WHERE isdraft = 'false'
GROUP BY YEAR(timestamp), MONTH(timestamp)
ORDER BY timestamp ASC