-
-
baohaochuan 小试身手Lv3
发表于2019-8-27 09:57
悬赏10
已解决
楼主
if(DATETOSTR(MR_BS_MINSL.START_DATE,"yyyy")<@year,
@year,
if(DATETOSTR(MR_BS_MINSL.START_DATE,"yyyy")=@year,
DATETOSTR(MR_BS_MINSL.START_DATE,'yyyymm')^'-'^DATETOSTR(MR_BS_MINSL.END_DATE,'yyyymm'),
@year^'01-'^DATETOSTR(MR_BS_MINSL.END_DATE,'yyyymm')))
我是这样嵌套的 它会报一个 inconsistent datatypes: expected NUMBER got CHAR不一致的数据类型:预期的数字得到CHAR
@year,
if(DATETOSTR(MR_BS_MINSL.START_DATE,"yyyy")=@year,
DATETOSTR(MR_BS_MINSL.START_DATE,'yyyymm')^'-'^DATETOSTR(MR_BS_MINSL.END_DATE,'yyyymm'),
@year^'01-'^DATETOSTR(MR_BS_MINSL.END_DATE,'yyyymm')))
我是这样嵌套的 它会报一个 inconsistent datatypes: expected NUMBER got CHAR不一致的数据类型:预期的数字得到CHAR
