随笔分类 -  database

sql:按年、月、日钻取时间
摘要:#按月排SELECT count(EN_NAME), DATE_FORMAT( CREATE_DATE, "%Y-%m" )FROM financeWHERE DATE_FORMAT( CREATE_DATE, "%Y" ) = "2016"GROUP BY DATE_FORMAT( CREATE_ 阅读全文
posted @ 2019-04-16 16:06 WU大雄 阅读(244) 评论(0) 推荐(0)