Thank you so much. If I have an entire column of datetime, do replace 2011-06-07 14:36:14.000 with the column name? I want to split all the time in the column into date and time, not just one date time.
I recommend you just change your column type to DateTime (assuming it is a text string at the moment).
Once it is stored as a true DateTime datatype, you can split it or manipulate it as necessary when you access the data. I do not recommend storing it in split columns.
If it's not practically useful, then it's practically useless.