Hi, I have a application using phoenix with Ecto to make queries on a postgres db. My db has fields with datetime in UTC format. I want to make queries on this db with Ecto considering the local timezone. from(u in User) |> where([u], u.created_at <= ^input_datetime) |> Repo.all The above query t…

This post solved the problem! [image] Functions used in db field Questions / Help Nice! I didn’t know about the timezone parameter of to_datetime. I had to use Timex.to_datetime after this expression to convert in UTC. Anyway, this fix the problem apparently! Thanks a lo…

Ecto query considering timezone

Questions / Help

claudiofls February 21, 2018, 8:38pm 5

This post solved the problem!