Home > Database > Mysql Tutorial > body text

Why is my PHP code displaying an incorrect ISO 8601 date?

Linda Hamilton
Release: 2024-11-10 17:58:02
Original
803 people have browsed it

Why is my PHP code displaying an incorrect ISO 8601 date?

Incorrect ISO 8601 Date Display using PHP

When attempting to display a datetime as an ISO 8601 formatted string, users may encounter incorrect output. Specifically, timestamps such as "17 Oct 2008" incorrectly display as "1969-12-31T18:33:28-06:00."

Misidentified Argument

The main issue lies in the structure of the provided code:

<?php echo date("c", $post[3]); ?>
Copy after login

Here, the second argument of the date() function is $post[3], which represents a database timestamp string. However, the date() function expects a UNIX timestamp as its second argument.

Solution: Converting Database Timestamp

To correct this, you need to convert your database timestamp into a UNIX timestamp using the strtotime() function. The corrected code becomes:

<?php echo date("c", strtotime($post[3])); ?>
Copy after login

By incorporating this change, the correct ISO 8601 formatted string will be generated, resolving the incorrect display issue.

The above is the detailed content of Why is my PHP code displaying an incorrect ISO 8601 date?. 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