best way to get records created today with Ecto Phoenix?

Question

Coming from Rails Active Record I was wondering how can i actually fetch records which are created today.

In Rails we can do it like this

User.where(created_at:Date.today.beginning_of_day..Date.today.end_of_day)

or much concise

scope :created_today, ->(date = Date.today) { where(created_at: date..date.end_of_day) }

User.created_today

what would be best way to implement same thing with Ecto??

Answer 1

Your best bet would be to use the Timex Library.

Using this library you could do something like this:

date = DateTime.today |> Timex.datetime

query = from m in Model, where: m.inserted_at >= ^Timex.beginning_of_day(date), where: m.inserted_at <= ^Timex.end_of_day(date)

Repo.all(query)