How to apply NOW() to timestamps field in MySQL Workbench?

Ankith Reddy

Answered on 13th Jun, 2019

Let us first create a table −

create table DemoTable
(
   Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   ShippingDate timestamp
);

Insert some records in the table using insert command. Here, we have included the current date with NOW() −

INSERT INTO DemoTable(ShippingDate) VALUES(now());

Display all records from the table using select statement −

SELECT *FROM DemoTable;

Output

Following is the screenshot of query in MySQL workbench to set NOW() to timestamp field “ShippingDate”. The query also displays the output below −