select count(id) from userlog group by substring(datestamp,1,10)