How to display a date as iso 8601 format with PHP

Posted by Matthew James Taylor on Stack Overflow See other posts from Stack Overflow or by Matthew James Taylor
Published on 2009-05-24T06:12:15Z Indexed on 2010/04/08 14:33 UTC
Read the original article Hit count: 316

Filed under:

iso-8601

|

php

|

mysql

|

datetime

I'm trying to display a datetime from my MySQL database as an iso 8601 formated string with PHP but it's coming out wrong.

17 Oct 2008 is coming out as: 1969-12-31T18:33:28-06:00 which is clearly not correct (the year should be 2008 not 1969)

This is the code I'm using:

<?= date("c", $post[3]) ?>

$post[3] is the datetime (CURRENT_TIMESTAMP) from my MySQL database.

Any ideas what's going wrong?

© Stack Overflow or respective owner

Related posts about iso-8601

How to display a date as iso 8601 format with PHP

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to display a datetime from my MySQL database as an iso 8601 formated string with PHP but it's coming out wrong. 17 Oct 2008 is coming out as: 1969-12-31T18:33:28-06:00 which is clearly not correct (the year should be 2008 not 1969) This is the code I'm using: <?= date("c", $post[3])… >>> More
Ecmascript 5 Date.parse for ISO 8601 test cases

as seen on Stack Overflow - Search for 'Stack Overflow'
What results is right for next test cases? //Chrome Opera Firefox IE 9 Safari console.log(Date.parse("2012-11-31T23:59:59.000Z"));//1354406399000 NaN NaN 1354406399000 NaN console.log(Date.parse("2012-12-31T23:59:59… >>> More
How to parse an ISO-8601 duration in Objective C?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for an easy way to parse a string that contains an ISO-8601 duration in Objective C. The result should be something usable like a NSTimeInterval. An example of an ISO-8601 duration: P1DT13H24M17S, which means 1 day, 13 hours, 24 minutes and 17 seconds. >>> More
In C#, given a DateTime object, how do I get a ISO 8601 date in string format?

as seen on Stack Overflow - Search for 'Stack Overflow'
Given: DateTime.UtcNow How do I get a string which represents the same value in an ISO 8601 compliant format? Note that ISO 8601 defines a number of similar formats: (Wikipedia). The specific format I am looking for is: yyyy-MM-ddTHH:mm:ssZ >>> More
Does Javascript/EcmaScript3 support ISO8601 date parsing?

as seen on Stack Overflow - Search for 'Stack Overflow'
How are you currently parsing ISO8601 dates e.g. 2010-02-23T23:04:48Z in JavaScript? Some browsers return NaN (including Chrome) when using the code below, FF3.6+ works though. <html> <body> <script type="text/javascript"> var d = Date.parse("2010-02-23T23:04:48Z"); document… >>> More

Related posts about php

Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU

as seen on Server Fault - Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem… >>> More
PHP Pear Installation on CentOS

as seen on Server Fault - Search for 'Server Fault'
[root@ip ~]# yum install php-pear* Reducing CentOS-5 Testing to included packages only Finished Setting up Install Process Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio … >>> More
Apache configurations for php "AddType text/html php" or "AddType application/x-httpd-php php .php"

as seen on Server Fault - Search for 'Server Fault'
I am taking over an application server and discover that it contain the following settings: AddType text/html php Although it works, but my understanding is that it should set as following: AddType application/x-httpd-php php .php What are the key differences between the two settings?… >>> More
mod_rewrite settings causes server to throw HTTP 500 errors instead of 404

as seen on Server Fault - Search for 'Server Fault'
Hello. I have a server with VBulletin forum (working under Apache 2.2, CentOS). The default settings for it in .htaccess are as follows: RewriteEngine on RewriteCond %{HTTP_HOST} ^gsmforum\.ru RewriteRule (.*) http://www.gsmforum.ru/$1 [R=301,L] # If you are having problems or are using VirtualDocumentRoot… >>> More
Problems installing Memcache (PECL extension)

as seen on Server Fault - Search for 'Server Fault'
I have installed memcached fine, and now I will need to install PECL extension memcache. Im running RedHat x86_64 es5. The installation gives me this: downloading memcache-2.2.6.tgz ... Starting to download memcache-2.2.6.tgz (35,957 bytes) ..........done: 35,957 bytes 11 source files, building running:… >>> More