Hi, need to convert a string MM-DD-YYYY into mysql format YYYY-MM-DD how can I do that ? Many thanks for help
toyug
<?php $str = "05-06-2003"; ereg("([0-9]{2})-([0-9]{2})-([0-9]{4})",$str,$str1); echo "str = ".$str."<br>"; $str2 = $str1[3]."-".$str1[2]."-". $str1[1]; echo "str2 = ".$str2."<br>"; ?>
//$date is in MM-DD-YYYY format $new=explode("-",$date); $newdate=$new[2] . "-" . $new[0] . "-" . $new[1];
thank you lads ;-) perfect !