SQL

TIMESTAMP型をUNIX秒に変換?

SELECT UNIX_TIMESTAMP(created_at) FROM TABLE_NAME;

日毎の集計

SELECT
    SUBSTRING(created_at, 1, 10) AS date,
    COUNT(*) AS count
FROM
    TABE_NAME
GROUP BY
    date