[SOLVED] Date Format Problem

[stevesimo]

Hi, I have a date in dd/mm/yyyy format i.e. 15/03/2007

 

The problem is that when I am storing this in MySql it uses yyyy/mm/dd format so the value stored in the DB ends up being 2015-03-20

 

Does anyone know how I can get around this problem?

 

Thanks

 

Steve

[kenrbnsn]

Try something like this:

<?php
function convdate($engdate) {
    list ($d, $m, $y) = explode('/',$engdate);
    return ($y . '-' . $m . '-' . $d);
}
$amerdate = convdate('15/03/2007');
echo $amerdate;
?>

 

Ken

[Orio]

Use explode()...

 

<?php
$date = "15/03/2007";

list($day, $month, $year) = explode("/", $date);
$new_date = $year."/".$month."/".$day;

echo $new_date;

?>

 

EDIT - Ken is faster

 

Orio.

[stevesimo]

Thanks guys, the code worked a treat!

 

Steve (Blackpool)