using split to format data?

[Anon]

I've read all the forums and can find anything like what i'm trying to do when formatting a date. So tell me if this is possible and if so maybe how I could go about it.

I have a csv file to upload to my db. The date is in the format of 8/20/2001.

Is there any way that I could split the date with the (/), assign is section a variable name and then format it properly in the db via the variable names?

[mikeq]

Hi,

This will take a date ($MyDateIn) and split it into variables $day, $month and $year.
it will accept the following date seperators /. or -

You can then use these variables in the mktime function and format it using the date function

---

list ($month, $day, $year) = split ('[/.-]', $MyDateIn);

$MyNewDate = date('Y-m-d H:i:s',mktime(0,0,0,$month,$day,$year));

---

Hope this helps
Mike

[Anon]

Any idea why this would come back null in the db all the time?

I'm loading the csv file and executing this command upon upload. Intro_date is the field with the 08/20/2001 format.

$newdate = $intro_date;
list($month,$day,$year) = split('/',$newdate);
$newdate = '$year-$month-$day';

mysql_query("UPDATE products SET new_date = ['$newdate']");

[mikeq]

Take away the [] brackets?