SQL

insert current date in mysql

INSERT INTO my_table (last_updated) VALUES(NOW());
INSERT INTO my_table (last_updated) VALUES(sysdate);	-- Oracle
INSERT INTO my_table (last_updated) VALUES(getdate());	-- SQL Server

mysql select or insert current datetime

SELECT now();
2021-07-26 22:08:15
the now() function returns the date and time when the query starts
the sysdate() function returns the exact date and time the query completes

select sysdate();
+---------------------+
| sysdate()           |
+---------------------+
| 2021-07-26 22:12:19 |
+---------------------+