Due to some changes, my application is producing screwed data because of the time format. The sql table that I am using stores time with and without colon. How can I make it so that all the records have a colon so that I can do time difference calculation?
This is how it looks:
Time
01:20 - (this is right)
23:40 - (this is right)
1150 - (this is wrong - Not getting colon)
22:10 - (this is right)
How can I make the column to have specific format with colon in between?
I looked at the thread and it says there should be an option for "Correct Answer" but I don't see it on my threads. However, I had to click on the heading link of the thread then I was able to mark the answer.
