sql server 2008 - How to convert varchar to datetime in T-SQL? - Stack Overflow
You will use a CAST() or CONVERT() on your field: Declare @dt varchar(20) set @dt = '08-12-2012 10:15:10' select convert(datetime, @dt, 101) For your query you would do the following: insert into table2 select s.acty_id, s.notes_datetime, s.notes_data fro...