Skip to content

Instantly share code, notes, and snippets.

@jacoyutorius
Created September 26, 2014 03:04
Show Gist options
  • Select an option

  • Save jacoyutorius/dccd7b0cc63d564ddf0f to your computer and use it in GitHub Desktop.

Select an option

Save jacoyutorius/dccd7b0cc63d564ddf0f to your computer and use it in GitHub Desktop.
Ransackで日付型のFrom-To検索をする ref: http://qiita.com/jacoyutorius/items/cf371bc449402a2676fa
Item.search(:created_at_gteq => "2014-09-10", :created_at_lteq => "2014-09-25").result.to_sql
=> "SELECT `items`.*
FROM `items`
WHERE ((`items`.`created_at` >= '2014-09-10 00:00:00'
AND `items`.`created_at` <= '2014-09-25 00:00:00'))"
<%= f.label :created_at_gteq %>
<%= f.text_field :created_at_gteq %>
<%= f.label :created_at_lteq %>
<%= f.text_field :created_at_lteq %>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment