I want to write query that basically results in appointment time . Here is whole picture I want . ![enter image description here](https://i.stack.imgur.com/zCE0N.png)

Problem is that Time column in FL\_CO\_APPOINTMENT table is varchar(50) and in desired column Appointment format is 09:00 - 11:00 01/12/2012 . How can I manipulate Time column which is varchar(50) to get result as mentioned from desired formula. I have google but didnt find any help. Thank you.