DB2 sql 上期（月、季、年）上月月末，上季末，上年末(统计中常用到)

时间:2013-03-04 18:53来源:未知作者:admin 点击: 次

分享到：

SELECT current timestamp -day(current date) days ,-- 上个月月末 ,能够知道跨年 CASE WHEN TO_CHAR('2012-01-01','Q') ='1' THEN to_char(year('2012-12-01')-1)||'-12' when TO_CHAR('2012-01-01','Q') ='2' THEN to_char(year('201

SELECT

current timestamp -day(current date) days ,-- 上个月月末 ,能够知道跨年

CASE WHEN TO_CHAR('2012-01-01','Q') ='1' THEN to_char(year('2012-12-01')-1)||'-12'
when TO_CHAR('2012-01-01','Q') ='2' THEN to_char(year('2012-12-01')-1)||'-3'
when TO_CHAR('2012-01-01','Q') ='3' THEN to_char(year('2012-12-01')-1)||'-6'
when TO_CHAR('2012-01-01','Q') ='4' THEN to_char(year('2012-12-01')-1)||'-9'
END AS tt , -- 上个季月

current date - (month(current date) -1 ) month - day(current date) day --上年年末

from sysibm.sysdummy1;

作者: housheng33
声明: 本文系ITeye网站发布的原创文章，未经作者书面许可，严禁任何网站转载本文，否则必将追究法律责任！

已有 0 人发表回复，猛击->>这里<<-参与讨论

ITeye推荐