QGIS: Function week(interval) does not exist

Question

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.

Answer 1

now() is a fickle companion. The moment you query it, it already is gone. Nail it down firmly using to_date() and at least until midnight it wont change.

Or, in a less poetic manner of speaking: You need to hand two datetimes of the same format & length to age(). Force now() into the same format as your end_time and you'll be fine.