Cheat Sheet PostgreSQL Dates, Times and Timestamps in PostgreSQL * adding/subtracting time SELECT now()::time - INTERVAL '10 min'; SELECT now() + INTERVAL '10 min';