set now value for timestamp postgresql code example

Example 1: postgres get timestamp

SELECT CURRENT_TIMESTAMP;

Example 2: substract variable amount of minutes from timestamp postgresql

SELECT p.date_time + number_of_seconds * INTERVAL '1 second'
    FROM photo p 
    WHERE p.id = 1;