2

Please login or register to vote for this query.

(click on this box to dismiss)

This counts how many new users there are each day. Broken down for easy graphing.

Q&A for Ubuntu users and developers

SELECT
    DATEADD(d, 0, DATEDIFF(d, 0, CreationDate)),
    COUNT(*)
FROM
        Users
GROUP BY
    DATEADD(d, 0, DATEDIFF(d, 0, CreationDate))
ORDER BY
    DATEADD(d, 0, DATEDIFF(d, 0, CreationDate))

fork query

edited sep 17 12

created sep 17 12 Oli