[moroose]

Hi all,
I'd like to convert a retrieved mysql datetime date format into a human readable format date in php.

PHP Code:

Start Date: 2007-05-11 20:32:17

End Date: 2008-11-12 00:17:54 

I know i can use the mysql date_format but in this script i dont want to create a select statement.I got the above result via sessions from previous pages.

can anyone please help with this?
thank you in advance

[BurakUeda]

ignore this.. will edit the post with a solution....

[UnrealEd]

use the strptime function:

PHP Code:

$format = "%Y-%d-%m %H:%M:%S";
print_r ($date, $format); 

[job0107]

You could do it like this:

PHP Code:

<?php
$_SESSION["start_date"]="2007-05-11 20:32:17";
$_SESSION["end_date"]="2008-11-12 00:17:54";
echo date("M d, Y H:i:s",strtotime($_SESSION["start_date"])).
     "<br />".
     date("M d, Y H:i:s",strtotime($_SESSION["end_date"]));
?>

Here I split the date and time and display it in a table.

PHP Code:

<style>
td
{
 padding-left:5px;
 padding-right:5px;
 }
</style>
<?php
$_SESSION["start_date"]="2007-05-11 20:32:17";
$_SESSION["end_date"]="2008-11-12 00:17:54";
echo "<table border=1>
       <tr><th colspan=2>Start</th><th colspan=2>End</th></tr>
       <tr><th>Date</th><th>Time</th><th>Date</th><th>Time</th></tr>
       <tr><td>".date("M d, Y",strtotime($_SESSION["start_date"]))."</td><td>".date("H:i:s",strtotime($_SESSION["start_date"]))."</td>
       <td>".date("M d, Y",strtotime($_SESSION["end_date"]))."</td><td>".date("H:i:s",strtotime($_SESSION["end_date"]))."</td></tr>
      </table>";
?>