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