I try to query with an expression I found in older posts:
week(age(now(),end_time)) <= 1
Where end_time
is of QDateTime
.
I am getting back:
An error occurred when executing the query.
The data provider said:
ERROR: function week(interval) does not exist
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
I tried with day
instead of week
and got a similar result.
Could you, please, help we to find out where I have a mistake.