Home > Database > Mysql Tutorial > How Can I Insert the Current Date and Time into a MySQL Table?

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

Barbara Streisand
Release: 2024-12-15 14:44:25
Original
998 people have browsed it

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()
);
Copy after login

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!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template