cognos实现同期和上月(informix库)【转载】
摘要:
同期: CASE WHEN MONTH(acnt21.date) = 2 AND DAY(acnt21.date) = 29 AND NOT MOD( 1, 4 ) = 0 THEN (acnt21.date + 1 UNITS DAY) + 1 UNITS YEAR - 1 UNITS DAY ELSE acnt21.date + 1 UNITS YEAR END as date, 目的:... 阅读全文
posted @ 2010-04-26 22:15 星星博客园 阅读(354) 评论(0) 推荐(0) 编辑