摘要：
Mysql语句：select substr(a.createtime, 1, 4) as statisticsName from defect1 a;select substr(a.createtime, 1, 7) as statisticsName from defect1 a;select substr(a.createtime, 1, 10) as statisticsName from defect1 a;Oracle语句一：select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from( sel 阅读全文
