Ecto query by date

query.exs

...
import Ecto.Query

date = ~D[2021-03-22]

# fetch by date
query = from a in Schema, where: fragment("?::date", a.createdAt) == ^date
Repo.all(query) # fetch

# fetch by range
query = from a in Schema, where: fragment("?::date", a.createdAt) >= ^start_date and fragment("?::date", a."createdAt") <= ^end_date
Repo.all(query) # fetch