By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Declare @YourTable Table ([ID] varchar(50),[date_time] varchar(50)) Insert Into @YourTable Values
(1,'1/24/2022 7:08:00 PM')
,(2,'1/24/2022 17:37')
,(3,'1/24/2022 9:36:00 PM')
,(4,'1/24/2022 22:14')
,(5,'Just a String')
,(6,'12/55/2022 6:30 AM') -- Bogus Date
Select ID
,date_time = try_convert(datetime,date_time)
from @YourTable
| ID | date_time |
|---|---|
| 1 | 2022-01-24 19:08:00.000 |
| 2 | 2022-01-24 17:37:00.000 |
| 3 | 2022-01-24 21:36:00.000 |
| 4 | 2022-01-24 22:14:00.000 |
| 5 | null |
| 6 | null |