September 21, 2015 How to convert string time to 24 Hours format in SQL. Declare @Test datetime Select @Test=CONVERT(datetime, '06:59PM' , 120) Select Cast(@Test as time(0)) Read more