MySQL Date to Human --- Gone Wild

[rlelek]

Anyone have any idea why this keeps returning the wrong date?

 

function mysql_date_to_human($dt)

{

    $yr=strval(substr($dt,0,4));

    $mo=strval(substr($dt,5,2));

    $da=strval(substr($dt,8,2));

  return date("d/m/Y", mktime (0,0,0,$da,$mo,$yr));

}

 

 

Example....

if the database column reads "2006-06-20"

it will output "06/08/2007" when the function is called.

 

Thanks for your help!

[darkfreaks]

<?php
return date("Y/m/d", mktime (0,0,0,$da,$mo,$yr)); ?>

[cooldude832]

easier

<?php
mysql_date_to_human($date){
return date("d/m/y", strtotime($date));
}
?>

[rlelek]

Thanks a Bunch

Wonderful help

 

Quick Response

 

Go PHPFreaks