
Untitled
By: a guest on
Apr 25th, 2012 | syntax:
None | size: 0.68 KB | hits: 9 | expires: Never
Count of records that are created the same day
[ [created_at date * 1000, count record for that date],
[created_at date * 1000, count record for that date],
[created_at date * 1000, count record for that date] ]
@kliks = Klik.all.map{|klik| [(klik.created_at.to_i * 1000), 1]}
@kliks = Klik.count( :group => "DATE( created_at )" )
SELECT *, COUNT(*) FROM kliks
GROUP BY DATE( created_at )
items = Klik.select("date(created_at) as creation_date, count(*) as count").group("date(creation_date)")
result = items.map { |k| [ k['creation_date'], k['count'] ] }
Klik.all.group_by do |k|
k.created_at.beginning_of_day
end.map do |date, records|
[date, records.length]
end