rubyonrails-talk
August 28th, 2006, 08:55 AM
Hey,
I'm doing some stats on how many music videos where recorded in the
previous week by using the following sql query:
select DATE_FORMAT(creation_date - interval 1 day, '%Y-%m-%d') as date,
count(artist) as total
from music_videos
group by DATE_FORMAT(creation_date - interval 1 day, '%Y-%u')
order by date desc
More... (http://groups.google.com/group/rubyonrails-talk/msg/98573415a0e6bc6e)
I'm doing some stats on how many music videos where recorded in the
previous week by using the following sql query:
select DATE_FORMAT(creation_date - interval 1 day, '%Y-%m-%d') as date,
count(artist) as total
from music_videos
group by DATE_FORMAT(creation_date - interval 1 day, '%Y-%u')
order by date desc
More... (http://groups.google.com/group/rubyonrails-talk/msg/98573415a0e6bc6e)