I have a field in SQL Server with datatype of Datetime. I'm selecting the date simply as
select impDate from tbl1
I am going to take a guess based on the information in the question that you are using the string value of the current date and time using
hh to retrieve the hours which is a 12 hour format. If you use string concatination to build up your sql (really bad, you should use parameters) this would explain the problem.
However, the fix is not to use military time to insert the date but to use a parameterized query and pass the DateTime instance directly to the value of the parameter.
Here is a quick example of how to use a parameter to avoid this type of issue in the future.
Public Function SomeFunction(ByVal dateToInsert As DateTime) Dim sql As String = "INSERT INTO tbl1 (impDate) VALUES(@impDate)" Using cn As New SqlConnection("Your connection string here"), _ cmd As New SqlCommand(sql, cn) cmd.Parameters.Add("@impDate", SqlDbType.DateTime).Value = dateToInsert cmd.ExecuteNonQuery() End Using End Function