Send all contents from one table to another and converting text date to realdate

[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)

[Barand]

try

CREATE TABLE tableB
SELECT col1, (STR_TO_DATE(col2, '%m/%d/%Y')) as col2, 
col3,col4,col5,col6 
FROM TABLE_A