Home > Backend Development > PHP Tutorial > Insert the current time in MYSQL, just like SQLSERVER's GETDATE(). (See inside)-Database related-P_PHP tutorial

Insert the current time in MYSQL, just like SQLSERVER's GETDATE(). (See inside)-Database related-P_PHP tutorial

WBOY
Release: 2016-07-13 16:58:15
Original
845 people have browsed it

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())

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631441.htmlTechArticleNOW() function returns the current date and time with `'YYYY-MM-DD HH:MM:SS', Can be stored directly into the DATETIME field. CURDATE() returns today's date in the format of 'YYYY-MM-DD', which can be saved directly to...
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template