I have an SQL table with a coloumn that has text entered in the following format 20051126173918 I need to convert that into andenter it in new coloumn created as a Date 2005/11/26 17:39:18 what do you suggest?. Below is how the table should look.
ID TEXT Date NEWDATE
3 some text 20051126173918 2005/11/26 17:39:18
6 moretext 20051226173914 2005/12/26 17:39:14