Answers for "set now value for timestamp postgresql"

SQL
1

postgres get timestamp

SELECT CURRENT_TIMESTAMP;
Posted by: Guest on December-12-2020
0

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

Code answers related to "SQL"

Browse Popular Code Answers by Language