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.
0
give a positive ratinggive a negative rating
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');
Share on FacebookShare on TwitterShare on LinkedInSend email
1 answer
x
x
2026 AnswerTabsTermsContact us