How Can I Insert the Current Date and Time into a MySQL Table?

How to Retrieve and Insert Current Date and Time in MySQL

SQL users often need to work with date and time values for accurate data management. Suppose you want to insert the current date and time into a MySQL table manually. How can you achieve this?

Using NOW() for Current Date and Time

MySQL provides a handy function called NOW() that returns the current timestamp. You can use it directly in INSERT statements to set a column's value to the current date and time. For instance:

INSERT INTO servers (
  server_name, online_status, exchange, disk_space, network_shares, c_time
)
VALUES(
  'm1', 'ONLINE', 'exchange', 'disk_space', 'network_shares', NOW()
);

In the example above, NOW() is used to automatically set the 'c_time' column to the current date and time upon insertion into the 'servers' table.

Considerations

• NOW() returns the timestamp with sub-second precision.
• MySQL automatically converts the returned timestamp to the appropriate data type for the column you're inserting into.
• You can also use other date and time functions in MySQL, such as CURDATE() for the current date and CURTIME() for the current time.

The above is the detailed content of How Can I Insert the Current Date and Time into a MySQL Table?. For more information, please follow other related articles on the PHP Chinese website!