# Login help - grouping records

**URL:** <https://www.ruby-forum.com/t/login-help-grouping-records/120673>\
**Category:** Rails\
**Created:** [November 19, 2007, 6:21pm UTC](https://www.ruby-forum.com/t/login-help-grouping-records/120673 "2007-11-19T18:21:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\
**Post date:** [November 19, 2007, 6:21pm UTC](https://www.ruby-forum.com/t/login-help-grouping-records/120673/1 "2007-11-19T18:21:48Z")

</div>

I have a long list of posts posted on different days and many posts  
every day. I want them to arrange like following…

## Date1

post1  
post2

## Date2

post3  
post4  
post5

How can I (say) group them to appear all posts of one date under their  
related headng.

Because records have so many different days, it is confusing me… I need  
some generic solution.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\
**Post date:** [November 19, 2007, 6:22pm UTC](https://www.ruby-forum.com/t/login-help-grouping-records/120673/2 "2007-11-19T18:22:47Z")

</div>

Err…it’s ‘logic help…’

---

<div class="post-metadata">

**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\
**Post date:** [November 19, 2007, 6:33pm UTC](https://www.ruby-forum.com/t/login-help-grouping-records/120673/3 "2007-11-19T18:33:14Z")

</div>

hello,  
check this post :  
[http://groups.google.com/group/rubyonrails-talk/browse\_thread/thread/921051b1844a1ddd/93cfa15e7c907e00?lnk=gst&q=month#93cfa15e7c907e00](http://groups.google.com/group/rubyonrails-talk/browse_thread/thread/921051b1844a1ddd/93cfa15e7c907e00?lnk=gst&q=month#93cfa15e7c907e00)  
almost the same thing you want to do (except it is per monthes not per  
days).

your query should look like it:  
Post.find :all, :group =\> “DATE\_FORMAT(date,‘%Y-%m-%d’)”

i’m not sure about DATE\_FORMAT synthax, it is a mysql function but  
psql user you must check it.

On Nov 19, 6:22 pm, “Vapor …” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)