Convert into datetime MySQL format.
Posted: Tue Jan 23, 2007 11:05 am
Hello,
I have one column with dates stored in VARCHAR like this: 14:08:41 Nov 20, 2006.
Now I need to move all rows in that table and insert them in another table where I need store the times in the datetime MySQL format.
So I need to convert all times like 14:08:41 Nov 20, 2006 into datetime like 0000-00-00 00:00:00. How can I do that?
Best Regards
I have one column with dates stored in VARCHAR like this: 14:08:41 Nov 20, 2006.
Now I need to move all rows in that table and insert them in another table where I need store the times in the datetime MySQL format.
So I need to convert all times like 14:08:41 Nov 20, 2006 into datetime like 0000-00-00 00:00:00. How can I do that?
Best Regards