-
-
baohaochuan 小试身手Lv3
发表于2019-8-27 14:23
悬赏10
已解决
楼主
if(DATETOSTR(MR_BS_MINSL.START_DATE,"yyyy") < ASSTR((@year-1)) and DATETOSTR(MR_BS_MINSL.END_DATE,"yyyy") > ASSTR((@year-1)),
ASSTR((@year-1)),
if(DATETOSTR(MR_BS_MINSL.START_DATE,'yyyy')=ASSTR((@year-1)),
ASSTR((@year-1))^'01-'^DATETOSTR(MR_BS_MINSL.END_DATE,'yyyymm'),
ASSTR((@year-1))^'01-'^@year-1^DATETOSTR(MR_BS_MINSL.END_DATE,'mm')
)
)
在这个if里我想让@year的参数-1应该怎么做
ASSTR((@year-1)),
if(DATETOSTR(MR_BS_MINSL.START_DATE,'yyyy')=ASSTR((@year-1)),
ASSTR((@year-1))^'01-'^DATETOSTR(MR_BS_MINSL.END_DATE,'yyyymm'),
ASSTR((@year-1))^'01-'^@year-1^DATETOSTR(MR_BS_MINSL.END_DATE,'mm')
)
)
在这个if里我想让@year的参数-1应该怎么做
最近看过此主题的会员
5个回答
问题解决记得关贴哟 设置最佳答案即可。
