I am trying to run the following command: "delete from invoice_log where now()-time > 120*60*60*24;"
and I get:
ERROR: operator does not exist: interval > integer LINE 1: delete from invoice_log where now()-time > 120*60*60*24; HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
so my formats both side of the comparison do not match. Can anybody pls. help me to improve that statement. Thank you ^