moving data from one table to another and coverting text date to real usable date

[0o0o0]

have two tables .. ones full of data.. and the other empty..

I want to move all from TABLE_A to TABLE_B.. while converting a text date to real DATE..

my guess...

$sql = "INSERT INTO TABLE_B SELECT col1, (STR_TO_DATE(col2, '%m/%d/%Y')) as col2, col3,col4,col5,col6 from TABLE_A ";

this does not work for me.. and the date does not convert.

see any errors?

( identical columns identical tables)

[devinemke]

are you using mySQL? if so the native date format is YYYY-MM-DD (not m/d/y)