Ò»¸ö¸ã²»Ã÷°×µÄoracleÎÊÌâ

´úÂ룺 select urrshis_serv_num
from urrshis
        where urrshis_prem_code=acct.ucracct_prem_code
          and nvl(urrshis_charge_date,'12/31/2099') = to_date('12/31/2099','mm-dd-yyyy')

±¨ ORA-01843: not a valid month 

µ«ÊÇÎÒÔÚsqlplus ÖР
 
SQL>  select to_date('July 12,2003','Month dd,yyyy') from dual;

TO_DATE('
---------
12-JUL-03

SQL> 

ÊÇ¿ÉÒÔÖ´ÐÐÕâÑùµÄÓï¾äµÄ£¬ÎÒÒ² alter session set nls_date_language=AMERICAN;

µ«»¹ÊDZ¨ ORA-01843: not a valid month 

---

nvlÌæ´úÖµÊÇvarchar2ÀàÐÍ£¬=ºóÃæÊÇdateÀàÐÍ£¬µ±È»±¨´í

---

nvl(urrshis_charge_date,'12/31/2099')
-->
nvl(urrshis_charge_date,to_date('12/31/2099','mm-dd-yyyy'))

---

¶Ô¡£ÎÒÔÎËÀ¿©

лл¡£½áÌû