GreenPlum之生成月份字典表
摘要:
--生成月份字典表 drop table if exists monthmapping; create table monthmapping as select cast(to_char(onday,'yyyymm') as integer) monthid,onday from ( select cast('2001-01-01 00:00:00' as timestamp) + (c ||... 阅读全文
posted @ 2017-07-10 23:27 BingCorePower 阅读(820) 评论(0) 推荐(0) 编辑