{"id":11719,"date":"2023-10-27T21:53:39","date_gmt":"2023-10-28T04:53:39","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=11719"},"modified":"2023-10-27T21:56:05","modified_gmt":"2023-10-28T04:56:05","slug":"mysql-insert-datetime","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-insert-datetime\/","title":{"rendered":"MySQL Insert DateTime"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to insert DATETIME<\/code> values into a table in MySQL database.<\/p>\n\n\n\n

Defining a DATETIME column<\/h2>\n\n\n\n

The DATETIME<\/a><\/code> data type is used to store both date and time values. To define a column with the DATETIME<\/code> data type, you use the following syntax:<\/p>\n\n\n

column_name DATETIME<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In practice, you use the DATETIME<\/code> columns to store both date and time values such as event times, logging times, and more.<\/p>\n\n\n\n
To insert data into the DATETIME<\/code> columns, you need to ensure that the datetime values are in the 'YYYY-MM-DD HH:MM:SS'<\/code> format.<\/p>\n\n\n\n
If you have datetime values in different formats, you need to format them to match the 'YYYY-MM-DD HH:MM:SS'<\/code> expected by MySQL.<\/p>\n\n\n\n
We’ll show you some examples of inserting data into the DATETIME<\/code> column.<\/p>\n\n\n\n
Inserting a datetime value example<\/h2>\n\n\n\n
First, create a table<\/a> called events<\/code>:<\/p>\n\n\n
CREATE<\/span> TABLE<\/span> events<\/span>(\n    id<\/span> INT<\/span> AUTO_INCREMENT PRIMARY KEY<\/span>,\n    event_name VARCHAR<\/span>(255<\/span>) NOT<\/span> NULL<\/span>,\n    event_time DATETIME NOT<\/span> NULL<\/span>\n);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The events<\/code> table has three columns:<\/p>\n\n\n\n