Tutorialspoint

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


1 Answer
Ankith Reddy

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 −

Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.