Fai così:

SELECT (now() - INTERVAL 20 DAY) as newdate;

Ciao