SELECT

  T.MR_DATE,

  T.BUSINESS_UNIT,

  T.CUSTOMER_TYPE,        

  T.PLATFORM, 

  T.PROVINCE,         

  T.CITY，

  T.LICENSE_NAME,

  T.SHOP_NAME,

  T.SHOP_TYPE,

  T.SOURCE,

  T.PRODUCT,

  T.SPECIFICATION,

  T.LISTING_PRICE,

  T.LAST_UPDATE_DATE

FROM STG_SG_LOW_PRICE_MONITORING_DETAIL T

WHERE 1=1

${if(len(P_PERIOD_NAME) == 0,""," AND

to_char(MR_DATE,'yyyy-MM') =to_char('" + P_PERIOD_NAME + "','yyyy-MM')")}

ORDER BY MR_DATE,BUSINESS_UNIT,CUSTOMER_TYPE DESC

P_PERIOD_NAME 是年月日，如上

P_PERIOD_NAME 是年月，如下

SELECT

  T.MR_DATE,

  T.BUSINESS_UNIT,

  T.CUSTOMER_TYPE,        

  T.PLATFORM, 

  T.PROVINCE,         

  T.CITY，

  T.LICENSE_NAME,

  T.SHOP_NAME,

  T.SHOP_TYPE,

  T.SOURCE,

  T.PRODUCT,

  T.SPECIFICATION,

  T.LISTING_PRICE,

  T.LAST_UPDATE_DATE

FROM STG_SG_LOW_PRICE_MONITORING_DETAIL T

WHERE 1=1

${if(len(P_PERIOD_NAME) == 0,""," AND to_char(MR_DATE,'yyyy-MM') ='" + P_PERIOD_NAME + "'")}

ORDER BY MR_DATE,BUSINESS_UNIT,CUSTOMER_TYPE DESC

控件和sql改成如下的格式即可

to_date('" + P_PERIOD_NAME + "','yyyy-MM')

日期控件返回

---------------------------------------------

SELECT

  T.MR_DATE,

  T.BUSINESS_UNIT,

  T.CUSTOMER_TYPE,        

  T.PLATFORM, 

  T.PROVINCE,         

  T.CITY，

  T.LICENSE_NAME,

  T.SHOP_NAME,

  T.SHOP_TYPE,

  T.SOURCE,

  T.PRODUCT,

  T.SPECIFICATION,

  T.LISTING_PRICE,

  T.LAST_UPDATE_DATE

FROM STG_SG_LOW_PRICE_MONITORING_DETAIL T

WHERE 1=1

${if(len(P_PERIOD_NAME) == 0,""," AND to_char(MR_DATE,'yyyy-MM') ='" + P_PERIOD_NAME+"'")}

ORDER BY MR_DATE,BUSINESS_UNIT,CUSTOMER_TYPE DESC