I’m running into a problem with processing my data in SQL, how do i go about converting data in the cell as shown below into HH:MM. I know this is in text and not formatted as date.
the data type in question
I know this is in text and not formatted as date. I can fix this in excel by using text to columns which would result in different cells containing the Hour and Minutes seperately and then converting them using a formula. How do i do this in SQL?
New contributor
Marvin Rabie is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.