Hello,
I have a query, where I’d like to grab all records still in the future.
def get_scheduled_notification_pushes_from_date(date\\DateTime.utc_now()) do
query = from s in ScheduledPush,
where: s.status not in ["completed", "cancelled"] and s.utc_schedule_time >= ^date
Repo.all(query)
end
I thought that this would possibly get converted or cast for postgres - but it must be doing something weird.
I also tried comparing ~U[] objects.. but that’s a bad idea…
iex(37)> ~U[2020-08-15 20:39:00.000000Z] >= ~U[2020-08-15 20:36:10.367654Z]
warning: invalid comparison with struct literal ~U"2020-08-15 20:39:00.000000Z". Comparison operators (>, <, >=, <=) perform structural and not semantic comparison. Comparing with a struct literal is unlikely to give a meaningful result. Modules typically define a compare/2 function that can be used for semantic comparison
false
How do I look for records based on a value that is ahead of DateTime.utc_now() with Ecto?
The type for utc_schedule_time is utc_datetime_usec
