oracle¼ÆËãÈÕÆÚµÄÎÊÌ⣡

дÁËÒ»¸ö°ü£¬°üÀïÓÐÒ»¸ö´æ´¢¹ý³Ì
´æ´¢¹ý³ÌÓÐÒ»¸ö´«Èë²ÎÊýºÍÒ»¸öÓαê
¹¦ÄÜ£º¸ù¾Ý´«ÈëµÄÈÕÆÚ£¬¼ÆËãÉÏÒ»¸öÔµÄÈÕÆÚ£¬È»ºó²éѯ³öÕâÁ½¸öÔÂÖ®¼äµÄÈ«²¿ÐÅÏ¢
µ«ÊÇ´æ´¢¹ý³Ì±¨´íÁË£¬¸÷λ°ïÎÒ¿´¿´£¬Ð»Ð»

create or replace package body PKG_T_BlogSearchDate
as
procedure PRO_T_BlogSearchDate(bgdate varchar2,mycur_out out mycur)
is
mm_temp date;--ÉÏÒ»ÔÂ
begin
select to_char(add_months(trunc(bgdate),-1),'yyyy-mm') into mm_temp from dual; --¸ù¾Ý´«ÈëÔ·ݣ¬»ñÈ¡ÉÏÒ»Ô·Ý
open mycur_out for
select * from t_blog where bg_date between mm_temp and bgdate order by bg_date desc;
end PRO_T_BlogSearchDate;
end PKG_T_BlogSearchDate;

´íÎóÐÅÏ¢£ºora-00932²»Ò»ÖµÄÊý¾ÝÀàÐÍ£ºÒªÇódateµÃµ½È´ÊÇnumber

---

1)
--±¨´íÔÚÕâÀ
select to_char(add_months(trunc(bgdate),-1),'yyyy-mm') into mm_temp from dual; --¸ù¾Ý´«ÈëÔ·ݣ¬»ñÈ¡ÉÏÒ»Ô·Ý

¸Ä³É£º
select add_months(to_date(bgdate || '-01', 'yyyy-mm-dd'), -1) into mm_temp from dual;

2)
select * from t_blog where bg_date between mm_temp and bgdate order by bg_date desc;
ÕâÀïÒ²ÓÐÎÊÌ⣬bg_date×Ö¶ÎÊÇʲôÀàÐ͵ģ¿

---

create or replace package body PKG_T_BlogSearchDate
as
procedure PRO_T_BlogSearchDate(bgdate varchar2,mycur_out out mycur)
is
mm_temp date;--ÉÏÒ»ÔÂ
begin
select to_char(add_months(trunc(bgdate),-1),'yyyy-mm') into mm_temp from dual; --¸ù¾Ý´«ÈëÔ·ݣ¬»ñÈ¡ÉÏÒ»Ô·Ý
open mycur_out for
select * from