我尝试用replace写sql语句,写得很长,但是有些问题: select .. from table where .. and replace(to_char(to_date('2003-11-3','yyyy-mm-dd'),'yyyy-mm'),'-','')>=replace(to_char(kssj,'yyyy-mm'),'-','') and replace(to_char(to_date('2003-11-3','yyyy-mm-dd'),'yyyy-mm'),'-','')<=replace(to_char(jssj,'yyyy-mm'),'-','');如果不要最后那个and的内容,也就是: select .. from table where .. and replace(to_char(to_date('2003-11-3','yyyy-mm-dd'),'yyyy-mm'),'-','')>=replace(to_char(kssj,'yyyy-mm'),'-',''); 是可以出来正确结果的 加上最后那个and的内容,就什么都出不来,也不报错,就是出现一个 2 敲回车后就变成SQL>了
2) > to_char(kssj) or > to_char(jssj)
AND TO_CHAR (SYSDATE, 'YYYYMM') <= TO_CHAR (DATE2, 'YYYYMM')
请问怎么在判断中转成'yyyymm'这种格式啊?
select .. from table where .. and replace(to_char(to_date('2003-11-3','yyyy-mm-dd'),'yyyy-mm'),'-','')>=replace(to_char(kssj,'yyyy-mm'),'-','') and replace(to_char(to_date('2003-11-3','yyyy-mm-dd'),'yyyy-mm'),'-','')<=replace(to_char(jssj,'yyyy-mm'),'-','');如果不要最后那个and的内容,也就是:
select .. from table where .. and replace(to_char(to_date('2003-11-3','yyyy-mm-dd'),'yyyy-mm'),'-','')>=replace(to_char(kssj,'yyyy-mm'),'-','');
是可以出来正确结果的
加上最后那个and的内容,就什么都出不来,也不报错,就是出现一个
2
敲回车后就变成SQL>了