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
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