How to Avoid \'0000-00-00 00:00:00\' When Inserting Dates into MySQL datetime Columns using PHP\'s date()?

Inserting Dates into MySQL datetime Columns Using PHP's date()

When attempting to insert a date into a MySQL datetime column using PHP's date() function, some users may encounter the error "0000-00-00 00:00:00" being inserted instead of the intended date. To rectify this issue, it is crucial to ensure that the format passed to the date() function aligns with MySQL's datetime format expectations.

Specifically, MySQL requires a format that numerically represents the date and time components, such as "2010-02-06 19:30:13". This format signifies the year, month, day, hour, minute, and second, respectively.

Therefore, to correctly insert a date into a MySQL datetime column using PHP's date() function, use the following format:

<code class="php">date('Y-m-d H:i:s')</code>

This format uses the numeric equivalents of the month and day, which are denoted by "m" and "d" respectively. It also uses the 24-hour format for the hour, represented by "H".

The above is the detailed content of How to Avoid '0000-00-00 00:00:00' When Inserting Dates into MySQL datetime Columns using PHP's date()?. For more information, please follow other related articles on the PHP Chinese website!