随笔分类 -  DataBase

PostgreSQL按年月日分组
摘要：Select EXTRACT(year from cast(joindate as timestamp)) as Year, EXTRACT(month from cast(joindate as timestamp)) as Month, EXTRACT(day from cast(joindat 阅读全文
posted @ 2017-03-29 20:39 苏州牛恋歌 阅读(1027) 评论(0) 推荐(0)