Team,

I have a TransactionDateTime column with data and time information together like this - 2016-03-14 03:32:44.000.

I am looking for a Split Function in SQL server 2005 that would split this column into two separate columns one for "Date" and another for "Time" and the final output will look like this.---- Date (2016-03-14) and Time (03:32:44.000)

```
TransactionDateTime            Date              Time
2016-03-1403:32:44.000         2016-03-14        03:32:44.000

```

Thanks.