在DW里的SELECT语句里能不能用daysafter,如果要日期比较后跟参数再比较该怎么做
gh502 2003-10-17 02:32:32 SELECT md_yd_ly.id,
md_yd_ly.dh_item,
md_yd_ly.gg_item,
md_yd_ly.ssrq,
md_yd_ly.bmdm,
md_yd_ly.kh_item,
md_yd_cy.ssrq,
daysafter( md_yd_ly.ssrq, md_yd_cy.ssrq ) as rq
FROM md_yd_ly,md_yd_cy
where rq = :参数