Using the base strings functions we can try:
SELECT
Date,
LEFT(Date, CHARINDEX(' ', Date) - 1) AS Date,
SUBSTRING(Date,
CHARINDEX(' ', Date) + 1,
CHARINDEX(' ', Date, CHARINDEX('-', Date) + 1) -
CHARINDEX(' ', Date) - 3) AS Time
FROM yourTable;
CLICK HERE to find out more related problems solutions.