Hi
I have a [time] field- varchar datatype and it has got values in mixed formats as below
14:24:00
07:00.0
10:00:56.7730000
54:80.0 (exclude wrong format)
I am trying to cast the field as time (0) but it is causing conversion error.
Can some one please help me with sort this out?
Thanks