[RESOLVED] converting feed date for datetime column

[BEFOR]

Inserting from a feed:

$sql = " INSERT INTO table SET

Start = '".mysql_real_escape_string( $record["START"] )."';

The feed of course displaying the "START" date, but as a text value, formatted:
mm-dd-yyyy

However looking to insert into a table datetime col:
yyyy-mm-dd

Can this conversion be done from such text values? If so how since I was not able to accomplish with strtotime.

[bradgrafelman]

STR_TO_DATE()

[BEFOR]

sorry for the delay - due to the fact that I've been unable to convert with mysql with the feed, and, there are other factors involved like that same feed field can apparantly hold text values like "urgent" and several not-entirely-known others, I've decided to abandon ship.

appreciate the thought bradgrafelman