postgres minus 1 year return time code example Example: current date in postgresql minus 1 day CURRENT_DATE-INTERVAL '1 DAY'