Date formatting help? Please?

[brianb]

Hi,

I have a date coming from an XML feed that looks like this:

2/28/2003

I want to convert it into a MySQL friendly format....how would I do this?

My usual code isn't working for me:

$release = date('Y-m-d', strtotime($date));

Any coding help is appreciated.

Thanks.

[Daggeth]

You could use eregi to pull values out of the variable... Im sure there is an easier, more compact function though...

[marque]

this is a work around perhaps it will help

$date = "2/28/2003";
$date = explode("/",$date);

$release = date("Y-m-d",mktime(0,0,0,$date[0],$date[1],$date[2]));