SELECT sup_date, COUNT(id) FROM users WHERE sup_date > "1199145600" AND sup_date < "1202774400" GROUP BY sup_date
is there a way to convert the timestamps to output dates???
my goal is to be able to query the amount of signups for each day for the past 30 days - maybe i'm going about it wrong..
"Things you can get access to, you should never memorize." -Albert Einstein
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin