Home > Article > Backend Development > Insert current time in php MYSQL_PHP tutorial
Insert current time in php MYSQL_PHP tutorial
- WBOYOriginal
- 2016-07-21 15:52:24914browse
The NOW() function returns the current date and time as `'YYYY-MM-DD HH:MM:SS', which can be directly stored in the DATETIME field.
CURDATE() returns today's date in the format of 'YYYY-MM-DD', which can be directly stored in the DATE field.
CURTIME() returns the current time in the format of 'HH:MM:SS', which can be directly stored in the TIME field.
Example: insert into tablename (fieldname) values (now())
Statement：
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
Previous article：Introduction to xml reading related functions in php 1_PHP tutorialNext article：Introduction to xml reading related functions in php 1_PHP tutorial