选择在一个时间范围内创建的记录，而不考虑创建日期 [英] Select records created between a time range regardless the date of creation

问题描述

我想选择一组在凌晨2点至凌晨3点之间创建的记录，而不管其创建日期如何.有什么办法可以做到这一点?

I want to select a set of records created between 2 am to 3 am, regardless of the date it was created. Is there any way to achieve this?

数据库:PostgreSQL

Database: PostgreSQL

推荐答案

在PostgreSQL中:

With PostgreSQL:

Model.where("created_at::time BETWEEN '14:00:00' AND '15:00:00'")

P.S.在处理时间查询之前，请确保您了解Rails的默认时区(UTC)以及与用户的时区差异有关的问题.

P.S. Before dealing with time queries make sure you are aware of the Rails default timezone (UTC) and issues connected to users' timezone differences.

这篇关于选择在一个时间范围内创建的记录，而不考虑创建日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！