Databases
StackOverflow2013
Postsdbo
POFinding minimum time from record and splitting it in LINQ
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFinding minimum time from record and splitting it in LINQ
    text
    copied!<p>We have a database of swimmers with their times. To create a ranking we want to get the fastest time of each athlete.</p> <pre><code>var rankings = ( from r in _db.Results orderby r.swimtime group r by r.athleteid into rg select new { AthleteId = rg.Key, FirstName = rg.Min(f2 =&gt; f2.Athlete.firstname), Swimtime = rg.Min(f8 =&gt; f8.swimtime), hours = rg.Min(f9 =&gt; f9.swimtime.Hours), minutes = rg.Min(f10 =&gt; ("00" + f10.swimtime.Minutes.ToString()).Substring(("00" + f10.swimtime.Minutes.ToString()).Length - 2)), // to get 2 digits in minutes seconds = rg.Min(f11 =&gt; ("00" + f11.swimtime.Seconds.ToString()).Substring(("00" + f11.swimtime.Seconds.ToString()).Length - 2)), // to get 2 digits in seconds milliseconds = rg.Min(f12 =&gt; (f12.swimtime.Milliseconds.ToString() + "00").Substring(0, 2)), // because miliseconds are not always filled } ); </code></pre> <p>Now the ranking is created correctly, however the time shown is not.<br> I know what the problem is, but don't know how to fix it:</p> <p>In the database we have a swimmer that has 2 times : 00:01:02:10 (1min2sec10) and 00:00:56:95 (56sec95)</p> <p>The result we get is the minimum for the minutes (=00), the minimum for the seconds (=02) and the minimum for the milliseconds (=10)<br> Resulting in a time of 00:00:02:10.</p> <p>What we should get is the hours,minutes,seconds and milliseconds of the fastest time (=00:00:56:95)</p> <p>Anyone any ideas on how to fix this ?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload