Formatting date with PHP

[marne]

Hi,

I am storing a date in a database (DATETIME) and I have retrieved the stored date to a variable in PHP.

Now, I want to edit the date format with PHP when I echo it. How to? I know there are other ways around this using MySQL to alter the date but I really want to do this using PHP code...

THANKS!!!

[thorpe]

[man]date/man.

[matto]

convert it into a timestamp using one of the date functions (e.g. mktime):

list of datetime functions: http://www.php.net/datetime
includes examples!

once you have the timestamp you can transform it as you like using the date() function (included in the above list), see the examples and postings there.

[marne]

I always thought that date() would automatically return the current date - not the stored one. Guess not.

This was useful (from php.net):

<?

$datetime = "20050905105237";

echo mydate("Y-m-d H:i:s", $datetime);
// Produces 2005-09-05 10:52:37

function mydate($format, $publictime)
{
       $sec = substr($publictime, 12, 2);
       $min = substr($publictime, 10, 2);
       $hour = substr($publictime, 8, 2);
       $day = substr($publictime, 6, 2);
       $month = substr($publictime, 4, 2);
       $year = substr($publictime, 0, 4);
       return date($format, mktime($hour, $min, $sec, $month, $day, $year));
}

?>

Thanks!