–yesterday<br /> SELECT NOW() – INTERVAL ‘1 DAY’;</p> <p>–Unrelated to the question, but PostgreSQL also supports some shortcuts:<br /> SELECT ‘yesterday’::TIMESTAMP, ‘tomorrow’::TIMESTAMP, ‘allballs’::TIME;

CURRENT_DATE-INTERVAL ‘1 DAY’