如何将日期时间转换为unix命令日期

Question

How do I convert 2014-10-10 04:13:24 to 2014-10-10T04:13:24+00:00 in php or mysql

The above mentioned date is for xml format in sitemaps

For reference check Q: How do I compute lastmod date? (Sitemaps.org FAQ)

code which i have tried:

    echo "GIVEN DATE ".$timestamp = "2014-10-10 04:13:24";
echo "<br>";

$year = date('Y',strtotime($timestamp)).";
$month = date('m',strtotime($timestamp)).";
$day = date('d',strtotime($timestamp))."";
echo '<br>';
$hour = date('H',strtotime($timestamp))."";
$minutes = date('i',strtotime($timestamp))."";
$seconds = date('s',strtotime($timestamp))."<br>";


$gmktime= gmmktime($hour,$minutes,$seconds,$month,$day,$year)."<br>";

echo "output date".$isodate = date('c', $gmktime);

is the above out put conversion correct?

**OUTPUT**

GIVEN DATE : 2014-10-10 04:13:24

output date : 2014-10-10T06:13:24+02:00

Answer 1

PHP 5:

<?php
// Set the default timezone
date_default_timezone_set('UTC');


// Get Unix timestamp for a date
// Reference: mktime(hour, minute, second, month, day, year)
$time = mktime(04, 13, 24, 10, 10, 2014);

// Alternatively (must be a valid English date format)
$time = strtotime('2014-10-10 04:13:24');


// ISO 8601 date (added in PHP 5)
$isodate = date('c', $time);

echo $isodate; // 2014-10-10T04:13:24+00:00


// RFC 2822 formatted date
$rfcdate = date('r', $time);

echo $rfcdate; // Fri, 10 Oct 2014 04:13:24 +0000
?>

References:

• date() / gmdate()
• mktime() / gmmktime()
• strtotime() : Supported Date and Time Formats
• date_default_timezone_set() : List of Supported Timezones
• ISO 8601
• RFC 2822