我有一个用来测试时间的查询。下面是两个例子: users.fname as counselor, SEC_TO_TIME(AVG(TIME_TO_SEC(TIMEDIFF(starttime, signintime)))) AS 'AVG Wait Time',
SEC_TO_TIME(AVG(TIME_TO_SEC(TIMEDIFF(finishtime, starttime)))) AS 'AVG
select SeasonPlayer).ToList();
SeasonPlayer有一个ICollection of StatisticsPlayer,所以我想得到一个由STP_timeplay命令下降的平均时间我不能用STP_timeplay求平均值,因为它不是小数,所以我试着用滴答来求平均值。