mysql - 不显示与上次日期相关的数据

Question

下面是查询

SELECT
users.userName,
rechannel.channelName,
trschedule.ContentType,
trprogram.programName,
trschedule.Description,
trschedule.startTime,
trschedule.endTime,
TIMEDIFF(trschedule.startTime,trschedule.endTime) AS Difference,
LENGTH(trschedule.Description) AS Charcter_Count,
ROUND( LENGTH(trschedule.Description)/6) AS Word_Count,
ROUND( LENGTH(trschedule.Description)/65) AS Line_Count,
trschedule.ProvinceName,
trschedule.CityName,
trschedule.AreaName,
trschedule.ContentTone,
trschedule.searchText,
trschedule.CountryName,
trschedule.transmissionDate,
trschedule.insDate
FROM users 
Inner Join trschedule ON users.userID = trschedule.insertID 
Inner Join rechannel ON rechannel.channelID = trschedule.channelID 
Inner Join trprogram ON trprogram.programID = trschedule.programID
WHERE (trschedule.insDate BETWEEN '2012-10-01' AND '2012-10-12')

但是结果显示从(insertDate)2012-10-01到2012-10-11，没有显示2012-10-12的数据。

有什么想法吗？？？/

Answer 1

我认为这应该可行，只需更改最后一行:

WHERE (DATE(trschedule.insDate) BETWEEN '2012-10-01' AND '2012-10-12')