Skip to content

Instantly share code, notes, and snippets.

@mrgcohen

mrgcohen/group_by_date_postgres.rb

Created August 1, 2014 13:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrgcohen/704e9ee770eb4fa19b2b to your computer and use it in GitHub Desktop.
Save mrgcohen/704e9ee770eb4fa19b2b to your computer and use it in GitHub Desktop.
Download ZIP
group by date postgres, nice cast
Raw
group_by_date_postgres.rb
Table.select("field1, created_at::timestamp::date").group("field1, created_at::timestamp::date")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment