DB2上一个季月SQL
DB2上一个季月SQL
CREATE FUNCTION "DB2INST1"."QTR" www.2cto.com
("DDATE" DATE
)
RETURNS CHARACTER(7)
SPECIFIC "DB2INST1"."SQL130225092927300"
LANGUAGE SQL
NOT DETERMINISTIC
READS SQL DATA
STATIC DISPATCH
CALLED ON NULL INPUT
EXTERNAL ACTION
INHERIT SPECIAL REGISTERS
BEGIN ATOMIC
DECLARE v CHARACTER(7) default '';
--declare cursor1 cursor for
set v= (
select
CASE
WHEN TO_CHAR(DDATE,'Q') ='1'
THEN to_char(year(DDATE)-1)||'-12'
when TO_CHAR(DDATE,'Q') ='2'
THEN to_char(year(DDATE))||'-03'
when TO_CHAR(DDATE,'Q') ='3'
THEN to_char(year(DDATE))||'-06'
when TO_CHAR(DDATE,'Q') ='4'
THEN to_char(year(DDATE))||'-09'
END
--into :v -- 上个季月 能够知道跨年
from sysibm.sysdummy1
fetch first 1 rows only ) ;
--fetch first 1 rows only
--set sum = a + b;
return v;
END;
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。