postgres subtract days from current date code example Example: current date in postgresql minus 1 day CURRENT_DATE-INTERVAL '1 DAY'