-
MySQL已经存在日期了,然后怎么按照季度查询?
2015-07-28 15:402015 年第一季度:
where DATADATE >= '2015-01-01 00:00:00' and DATADATE <= '2015-03-31 23:59:59';
2015 年第一季度: where DATADATE >= '2015-01-01 00:00:00' and DATADATE <= '2015-03-31 23:59:59';