Insert or update current date in DATETIME format - SQL

What SQL function should I use to insert or update current date in DATETIME format in table cell ? I tried to use GETDATE() but it is not working.

07 Dec 2020 at 04:26 PM

Stor

Hi,

To insert actual date into table cell, you can try to use NOW().

The SQL should look like:

INSERT INTO product_updates (id_update, id_product, id_user, date, status) VALUES (NULL, 10, 25, NOW(), 'new');

09 Dec 2020 at 10:07 AM

Tim

Insert or update current date in DATETIME format - SQL

Error: Illegal parameter data types INT and row for operation '='

Is faster one big SQL query or multiple small SQL queries ?

Copy and update rows in the same table with autoincrement - SQL

MySQL error: Unknown table engine 'InnoDB' - how to fix ?

Fix SQL error Index for table 'user_db' is corrupted, try to repair it

Error: You can't specify target table for update in FROM clause

SQL query with SELECT COUNT() in SELECT - subquery example