Will Varchar Automatic Convert Into Datetime ?

hi, good day, if i have a table as follow:

Create table test
(
student_name varchar(20),
student id varchar(20),
register_dt varchar(50)
)


and insert data like


insert into test values('rebecca','0001','2006-08-08 12:15:03')


after all , i would like to query the data and insert into another table say data_tbl where it define as follow

Create table data_tbl
(

student_name varchar(20),
student id varchar(20),
register_dt datetime
)


would the test table regiter_dt auto convert into datetime format or we need to convert it before insert into data_tbl table?