Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks you.
Hi,
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.
Thanks.