Answers for "postgres query for timestamp range"

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;

Posted by: Guest on October-16-2020

timestamp(0) postgresql

(now())::timestamp(0))

Posted by: Guest on January-09-2021

Code answers related to "postgres query for timestamp range"