Ecto查询两个日期之间的差异，单位为分钟

defmodule MyApp.Event do
  use Ecto.Schema

  schema "events" do
    field :start_time, :utc_datetime
    field :end_time, :utc_datetime
    # 其他字段...
  end
end

import Ecto.Query

start_time = DateTime.utc_now() # 假设为当前时间
end_time = DateTime.utc_now() # 假设为当前时间

query = from e in MyApp.Event,
        where: e.start_time >= ^start_time and e.end_time <= ^end_time,
        select: fragment("extract(epoch from (? - ?)) / 60", e.end_time, e.start_time)

result = MyApp.Repo.one(query)