blocks|key|1023929|text|MySQL：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1023930|Model.all+:condition+=>+["DATE(created_at)+=+?",+Date.today]+#+rails+2
Model.where("DATE(created_at)+=+?",+Date.today)+#+rails+3|code-block|syntax|javascript|1023931|PostgreSQL：|1023932|Model.all+:condition+=>+["created_at::date+=+?",+Date.today]+#+rails+2
Model.where("created_at::date+=+?",+Date.today)+#+rails+3|1023933|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

MySQL:

<pre><code>Model.all :condition =&gt; ["DATE(created_at) = ?", Date.today] # rails 2
Model.where("DATE(created_at) = ?", Date.today) # rails 3
</code></pre>

PostgreSQL:

<pre><code>Model.all :condition =&gt; ["created_at::date = ?", Date.today] # rails 2
Model.where("created_at::date = ?", Date.today) # rails 3
</code></pre>

blocks|key|1023988|text|Post.where(created_at:+Time.zone.now.beginning_of_day..Time.zone.now.end_of_day)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1023989|PS:这个答案已经被Harish+Shetty修改为比我更好的答案。因为我的回答是被接受的。我已经更新了这个答案以获得社区支持。|unstyled|1023990|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>Post.where(created_at: Time.zone.now.beginning_of_day..Time.zone.now.end_of_day)
</code></pre>

PS: This answer has been modified as answer by Harish Shetty was better than mine. As my answer is accepted one. I have updated this answer for community support

blocks|key|1024013|text|Mohit的答案改编成了Rails3|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1024014|Model.where+"DATE(created_at)+=+DATE(?)",+Time.now|code-block|syntax|javascript|1024015|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Mohit Jain's answer adapted for Rails3

<pre><code>Model.where "DATE(created_at) = DATE(?)", Time.now
</code></pre>

blocks|key|1024045|text|model.rb|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1024046|scope+:posted_today,+->+{+posted_between_period(Time.now.midnight,+Time.now.end_of_day)+}|code-block|syntax|javascript|1024047|posts_controller.rb|1024048|Post.posted_today|1024049|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

model.rb

<pre><code>scope :posted_today, -&gt; { posted_between_period(Time.now.midnight, Time.now.end_of_day) }
</code></pre>

posts_controller.rb

<pre><code>Post.posted_today
</code></pre>

blocks|key|1024103|text|Post.where(created_at:+Time.zone.now.beginning_of_day..Time.zone.now.end_of_day)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1024104|这个“命名作用域”用table_name表示该属性。|1024105|entityMap^0|0|28|0|A|A|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

<code>Post.where(created_at: Time.zone.now.beginning_of_day..Time.zone.now.end_of_day)
</code>

This "namescopes" the attribute with the <code>table_name</code>.

blocks|key|1238884|text|由于某种原因，本文中的其他解决方案和StackOverflow上的其他解决方案都不适用于我(使用Rails+4.2.4和Ruby2.2.3p173)。这是我可以使用Postgres数据库的唯一查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1238885|Post.where("created_at+>=+TIMESTAMP+'now'")|code-block|syntax|javascript|1238886|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For some reason, none of the other solutions in this post nor others on StackOverflow worked for me (using Rails 4.2.4 and Ruby 2.2.3p173). This is the only query that I could get to work with my Postgres database: 

<pre><code>Post.where("created_at &gt;= TIMESTAMP 'now'")
</code></pre>

blocks|key|1238941|text|Rails5.1有一个在这里很有用的all_day助手。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1238942|Post.where(created_at:+Date.today.all_day)|code-block|syntax|javascript|1238943|或|1238944|Post.where(created_at:+Date.parse("YYYY-MM-DD").all_day)|1238945|entityMap^0|I|7|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

Rails 5.1 has an <code>all_day</code> helper that's useful here.

<pre><code>Post.where(created_at: Date.today.all_day)
</code></pre>

or

<pre><code>Post.where(created_at: Date.parse("YYYY-MM-DD").all_day)
</code></pre>

How should I write the conditional statement for when I want to get all the records which were created today?

How to get record created today by rails activerecord?

PostgreSQL

数据库

MySQL

当我想要获取今天创建的所有记录时，我应该如何编写条件语句？

问如何获取rails activerecord今天创建的记录？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取rails activerecord今天创建的记录？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取rails activerecord今天创建的记录？
EN