Different time formats

[Neha11]

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 as in hours 

Please help 

@EbruErsan , @Pedro Lopes 

Thanks 

[#2]

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.

[#3]

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