October 29, 2008 at 12:55 PM
Plz give full details with source code to solve the problem.
October 29, 2008 at 1:40 PM
thnx for replying first of all.
i hav a dateTime field named match_DateTime , it contains a GMT-based dateTime which is a match Start time. match duration is 2 hours and i am working on live updates of this. for each time-interval end app lookinto the db and gets the games list.
all i did is
select * from matchlist where match_DateTime = getDate() // this results the match list items specifically at system date& time
select * from matchlist where match_DateTime >= getDate()
// this results the match list items specifically at system date& time and greater implies all wot is in schedule
i want the list of matches that are playing