Question

How to insert current datetime (timestamp) with insert query in PostgreSQL

Answer 1

INSERT INTO table_name (first_name, last_name, password, date_created, email) 
VALUES('fname', 'lname', 'pass123', current_timestamp, 'name@email.com');

SELECT first_name, to_char(date_created, 'yyyy-mm-dd hh:mi:ss') as current_date
FROM "table_name"

--- first_name   current_date
--- Avi          2020-05-08 05:35:46

 

70+ SQL courses for beginners and professionals