User-1370056497 posted
Hi All
This one has me running around and around
I am building a timing system as below. I need to show the result as "hh:mm:ss.fff"
My problem is the fff (milliseconds) do not save in the Sql data base correctly.
=======================================================
Dim StartTime as Datetime
Dim StopTime as DateTime
Dim strRunTime as Timespan
strRunTime = FinishTime.Subtract(StartTime)
Then save all three.
All three fields in the Sql are DateTime
Dim ts2 As TimeSpan = strRunTime
Dim dt3 As New DateTime(1, 1, 1, ts2.Hours, ts2.Minutes, ts2.Seconds, ts2.Milliseconds)
Dim mydataSave As String = "Data Source=RONS64BIT\SQLEXPRESS;Initial Catalog=ResultsData;Integrated Security=True;"
Dim Sqlconn As SqlConnection = New SqlConnection(mydataSave)
Dim query As String = "UPDATE LogData SET StopTime= @StopTime, tRunTime= @tRunTime, PenaltyCode= @PenaltyCode, Penalies= @Penalies WHERE logID='" & Myx & "'"
Dim cmd As New SqlCommand(query, Sqlconn)
cmd.Parameters.AddWithValue("@StopTime", DateTime.Parse(MyFinishTime.ToString("hh:mm:ss.fff")))
cmd.Parameters.AddWithValue("@tRunTime", DateTime.Parse(dt3.ToString("hh:mm:ss.fff")))
cmd.Parameters.AddWithValue("@PenaltyCode", strPenaltyCode)
cmd.Parameters.AddWithValue("@Penalies", strTotalPenalty)
cmd.Connection.Open()
Try
cmd.ExecuteNonQuery()
' MsgBox("Update all OK ")
Catch ex As Exception
Throw New Exception("Error " + ex.Message)
End Try
so the Results field is saved with the dt3
Stored in the Database as
StartTime = 2016-05-16 11:01:48.017
Finish Time = 2016-05-16 11:01:51.290
Results = 2016-05-16 00:00:03.260
so if you subtract 48.017 from the 51.290 you get 3.273 not the 3.260 as save in the database
This is a good one for the maths people
Hope someone can help
Regards
Ron B
