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. | |||||||||||
| |||||||||||
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'); | |||||||||||
| |||||||||||
| |||||||||||
![]() ![]() ![]() ![]() | |||||||||||
2022 AnswerTabs | Terms | Contact us |