mysql中时间日期的处理
1、
select SrcAPID as APID,year(statDate) as dateY,month(statDate) as dateM,TicketFlag as bsType,
sum(length) as applyCount,sum(case when msgstatus='DELIVRD' then length else 0 end) as successCount,
原创
2013-12-26 14:47:15 ·
638 阅读 ·
0 评论