Forum Discussion
Different time formats
Hi Everyone, I have one time col which has different time formats Time 3333 567 1hour 45 minutes 1 Day 3 hours 5 minutes 1 Day 4 hours 7 minutes 6 sec 456 8745 How do I make one format a...
I have one time col which has different time formats
Neha11 , no, you don't have a time column, you have a varchar column with trash data.
And you have to convert every individual "trash" in an individual way.
- Thanks for replying!
Any idea how to handle this
Can we use case when?
But how will I convert 1day 3 hours 45 minutes in a single row as hours
