要正确转换或查询Rails/MySQL DateTime列的日期范围,您可以使用Rails的Active Record查询方法。以下是一些示例:
Model.where(created_at: start_date..end_date)
Model.where("created_at <= ?", date)
Model.where("created_at >= ?", date)
Model.where("created_at <= ?", Time.now.beginning_of_day)
Model.where("created_at >= ?", Time.now.end_of_day)
Model.where("created_at <= ?", Time.now.yesterday.end_of_day)
Model.where("created_at >= ?", Time.now.yesterday.beginning_of_day)
Model.where("created_at <= ?", Time.now.beginning_of_week)
Model.where("created_at >= ?", Time.now.end_of_week)
Model.where("created_at <= ?", Time.now.beginning_of_month)
Model.where("created_at >= ?", Time.now.end_of_month)
Model.where("created_at <= ?", Time.now.beginning_of_year)
Model.where("created_at >= ?", Time.now.end_of_year)
请注意,这些查询方法仅适用于Rails应用程序,并且假定您已经有一个名为“Model”的Active Record模型,其中包含一个名为“created_at”的DateTime列。您需要根据您的实际应用程序和数据库表结构进行调整。
领取专属 10元无门槛券
手把手带您无忧上云