MyApp.Order
|> where([m], m.inserted_at > datetime_add(^Ecto.DateTime.utc, -2, "week"))
|> where([m], m.inserted_at < datetime_add(^Ecto.DateTime.utc, 0, "week"))datetime_add(^Ecto.DateTime.utc, 0, "week")似乎不像本周那样。因此,该查询获取上周和当前周的记录。
或者,
defp weekly_orders do
{interval1, interval2} = week_intervals
MyApp.Order
|> where([m], m.inserted_at >= datetime_add(^Ecto.DateTime.utc, ^interval1, "day"))
|> where([m], m.inserted_at < datetime_add(^Ecto.DateTime.utc, ^interval2, "day"))
end
defp week_intervals do
{-(day_of_the_week + 6) , -(day_of_the_week - 1)}
end
defp day_of_the_week do
:erlang.date
|> :calendar.day_of_the_week
end这在周一失败了,因为datetime_add(Ecto.DateTime.utc, 0, "day")
datetime_add(Ecto.DateTime.utc, 0, "day")返回或表示什么?发布于 2015-11-30 13:53:39
datetime_add(Ecto.DateTime.utc,0,"day")将0天添加到当前的日期时间,因此它基本上什么也不做。
我会在这里使用日期而不是约会时间,因为你真的更感兴趣的只是一周中的几天。所以也许就像
distance_to_monday = -(:erlang.date |> :calendar.day_of_the_week) + 1
distance_to_sunday = 7 - (:erlang.date |> :calendar.day_of_the_week)
MyApp.Order
|> where([m], m.inserted_at >= date_add(^Ecto.Date.utc, ^distance_to_monday, "day"))
|> where([m], m.inserted_at <= date_add(^Ecto.Date.utc, ^distance_to_sunday, "day")发布于 2017-04-12 07:53:04
您需要使用蒂梅克斯
room_messages = Repo.all(
from m in Message,
where: m.inserted_at >= ^Timex.beginning_of_day(Timex.now), where:
m.inserted_at <= ^Timex.end_of_day(Timex.now),
)发布于 2021-09-17 01:19:41
我想你不用Timex就能做到
room_messages = Repo.all(
from m in Message,
where: m.inserted_at >= ago(1, "week")
)https://stackoverflow.com/questions/33998296
复制相似问题