postgresql date minus 1 hour code example Example: current date in postgresql minus 1 day CURRENT_DATE-INTERVAL '1 DAY'