Dot1x

直接上代码：SELECT dealDate,strftime('%Y-%m',dealDate) as yearMonth FROM main.test4 GROUP BY yearMonth ORDER BY yearMonth ASC;结果如下dealDate是原始时间列，yearMonth是格式化之后的列dealDate yearMonth2010-12-15 2010-122012-02-26 2012-022012-03-30 2012-032012-04-29 2012-