displaying current minute of a soccer match

Posted by zurna on Stack Overflow See other posts from Stack Overflow or by zurna
Published on 2010-04-13T23:28:57Z Indexed on 2010/04/13 23:33 UTC
Read the original article Hit count: 305

Filed under:

I could not figure out the logic I would need to display a current minute of a soccer match. I have three fields in the database.

DateFirstStarted DateSecondStarted DateFullEnded

I should enter DateFirstStarted when the game starts and on the website. i.e. game starts at 7:05pm, on 7:25pm it should display '20 on the website. However, it should stop on the 45th minute. Then, I enter DateSecondStarted when the second half starts and should count from 46 to 90 and freeze there. Do I make sense? How can I do it? Is there a better way to do this?

© Stack Overflow or respective owner

Related posts about asp-classic