[SOLVED] How to convert d/m/y => y/m/d?

[A JM]

Is there a simple function for converting a date in "m/d/y" format to mysql datetime format of "y-m-d"?

 

A JM,

[jamesxg1]

Hiya mate,

 

This works, Im sure there are easier ways but it works at the end of the day.

 

<?php

$change = "17/08/2009";

list($date, $month, $year) = explode("/", $change);

$date =  $date . '-' . $month . '-' . $year; 

echo $date;

?>

 

James.

[roopurt18]

I'm not sure if strtotime() understand the m/d/y format, but I use date( 'Y-m-d H:i:s', strotime( $orig ) ) a lot.

[HoTDaWg]

this isnt the perfect solution but id just:

<?php
$string = 'd/m/y';
$newstring = explode('/',$string);
array_reverse($newstring);
$finalstring = implode('/',$newstring);
?>

 

hope this helps!

 

HoTDaWg

[ironhamster88]

Or even....

 

<?php
$old_date = '01/21/2009'; // or date('m/d/y') or whatever
$new_date = date('Y-m-d', strtotime($old_date));
?>

 

 

** edit **

aah that's pretty much what roopurt18 said, whoops :-P

[A JM]

Thanks for all the input.