Trying to convert a varchar to timestamps(6) in select query

General
Enthusiast

Re: Trying to convert a varchar to timestamps(6) in select query

Turns out there are some dates in wrong format in my table. 

 

Dates in Wrong format:

12/28/2015 9:55
1/11/2016 16:50
5/24/2016 12:29
10/10/2016 8:15
5/6/2017 13:28
2/23/2017 9:50
3/20/2016 12:16
3/20/2016 12:16

 

I need to figure out a regex logic to add the seconds and milli seconds when they are missing.