DailyLogDate什么类型? 如果是DATETIME型 date(DailyLogDate)>... and date(DailyLogDate)<.....
看看十六进制的ProjectCode什么内容select ProjectCode,hex(ProjectCode) from dailylogline where ProjectCode='pro-166' and DailyLogDate>='2014-01-01' and DailyLogDate<='2014-10-01' and LogState=2;
如果是DATETIME型
date(DailyLogDate)>... and date(DailyLogDate)<.....
服务器下命令行手动取数据