MyMans

created = поле с unix timestamp

SELECT count(nid), FROM_UNIXTIME(n.created, ‘%Y %d %m’) as created_day  FROM node n group by created_day

This entry was posted on Thursday, June 18th, 2009 at 9:48 am and is filed under mySql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.