【substr】mysql以天为单位查看当月每天的数据量sql
sql语句：select count(*),substr(t.openOrderTime,1,10) from tbl_Workorder_Work_Order t where t.openOrderTime like '2018-05%' group by substr(t.openOrderTime,1,10)
效果：
sql语句：select count(*),substr(t.openOrderTime,1,10) from tbl_Workorder_Work_Order t where t.openOrderTime like '2018-05%' group by substr(t.openOrderTime,1,10)
效果：