postgres timestamp now minus a day code example Example: current date in postgresql minus 1 day CURRENT_DATE-INTERVAL '1 DAY'