Different time formats

Question

Hi Everyone,I have one time col which has different time formatsTime33335671hour45 minutes&nbsp;1 Day 3 hours 5 minutes&nbsp;1 Day 4 hours 7 minutes 6 sec4568745How do I make one format as in hours&nbsp;Please help&nbsp;EbruErsan&nbsp;, Pedro Lopes&nbsp;Thanks&nbsp;

olafhelper · Answer

I have one time col which has different time formatsNeha11&nbsp;, 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.&nbsp;

neha11 · Answer

Thanks for replying!Any idea how to handle thisCan we use case when?But how will I convert 1day 3 hours 45 minutes in a single row as hours

Forum Discussion

Different time formats

Share

Resources