Forum OpenACS Q&A: Response to Date Math with bind variable emulation in postgresql

Alternatively, you could say

now() - interval(:the_interval)

where the_interval is '1 days' or similar.

Of course, then you have to change the code somewhat, too.