Well, you could use the
Time[
^] datatype...
"thanx for ur reply,if i use break point and i will see 24 hrs format with literals,but after inserting into sql server it will time only ,not save literals and also 12 hr format only"
Depends on how you are inserting it. This works for me:
Using con As New SqlConnection(strConnect)
con.Open()
Using cmd As New SqlCommand("INSERT INTO Table_1 (tm) VALUES (@TM)", con)
Dim dt As DateTime = DateTime.Parse("01:33:33 PM")
Dim ts As TimeSpan = dt - dt.[Date]
cmd.Parameters.AddWithValue("@TM", ts)
cmd.ExecuteNonQuery()
End Using
End Using