µ±oracle³öÏÖ ¸ñʽÓë×Ö·û´®¸ñʽ²»Æ¥Åä½â¾ö°ì·¨

    select v.spid spid,v.appid appid,v.version version,v.newversion newversion,v.status status,v.createtime createtime from adc_spversionchangeapply v inner join adc_application a on a.id=v.appid
    where a.create_by = 'a' and v.appid = '12000000005' and  (v.createtime >= '1987-05-06') and (v.createtime <= '2009-04-29')
¼ÓÈëv.createtimeÔÚÊý¾Ý¿âÖÐÊÔdateÀàÐÍ  ÄÇô»áÅܳöÒì³£
ORA-01861: ÎÄ×ÖÓë¸ñʽ×Ö·û´®²»Æ¥Åä
ʵ¼ÊÉÏÊÇÒòΪ '1987-05-06'ÊÇ×Ö·û´®ÀàÐ͵¼ÖµÄdateÀàÐÍÓë×Ö·û´®ÀàÐÍ ¼þ¿çÀàÐÍ±È½Ï ËùÒÔÊÇÓÐÎÊÌâµÄ
½«'1987-05-06'  д³Éto_date('1987-09-18','yyyy-mm-dd')
¾ÍÐÐÁË
´úÂëÈçÏÂ
    select v.spid spid,v.appid appid,v.version version,v.newversion newversion,v.status status,v.createtime createtime from adc_spversionchangeapply v inner join adc_application a on a.id=v.appid
    where a.create_by = 'a' and v.appid = '12000000005' and  (v.createtime >= to_date('1987-05-12','yyyy-mm-dd')) and (v.createtime <= to_date( '2009-04-29','yyyy-mm-dd')