Ok, simplified version is:
Table with 3 Rows. RecStartTime, RecStopTime, SpeechFileLen
Table name= ThroughPutData
Rcgstart = the recognition start time
Rcgstop = the recognition stop time
SoundFileLen = the length of the sound files =)
I want to write a statement that will add the sum of the sound file lengths between a specified amount of time. I have the following statement:
SELECT SUM(SpeechFileLen) AS SumSpeechFileLen
WHERE (RecStartTime >= 1156845634) AND (RecStopTime <= 1156849234)
The length of time I am looking for is 1 hour. The values for RecStartTime are in seconds from something like the year 1950 or some freaky stuff like that. Either way the numbers themselves do not matter, only that they stop time value is 1 hour after the start time (so start time+3600=stop time value)
Only problem is, executing the above statement gives me the result of SumSpeechFileLen=24hours+ which is impossible.
The whole idea of this is to work out how many seconds of recorded speech the system can recognise in 1hour.
Rogue Class Master.