benonymus
Hey there,
I have this code:
from(
ge in query,
join: e in assoc(ge, :event),
where: e.start_date <= ^date
)
As we know this can cause problems because of the date/datetime comparisons as it is described here for example : Date — Elixir v1.20.2
my questions is then how could I use DateTime.compare/2 with e.start_date here as the first argument?
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Practical resources that improve the lives of professional developers.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #elixirconf-eu
- #metaprogramming
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
Bringing learning, work and compliance together since 1987.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
NobbZ
As far as I remember, ecto does translate this into proper comparison on the SQL level, and the
DateDtimestruct isn’t actually involved in the comparison.benonymus
It seems like we have this phantom bug that a counter depending on this sometimes is not correct
alxvallejo
@NobbZ - Are you suggesting you can use normal comparison operators in the query and that solutions such as this: Comparing dates and times in Elixir with Ecto - DockYard are pointless?
@benonymus - I’m not even sure what you’re saying
NobbZ
The linked article is 4 years old and probably refers to a version of elixir that is not only deprecated but literally dead.
At the time the article got released, ecto 1.0.7 was current. Today we are at 3.2.2.
The
Ecto.DateTimemodule has been deprecated in 2.2.4.So I won’t say that article is pointless, I’d just say its not applicable anymore today, but it might have had its worth back the day it has been published.