这个是字段的日期格式,下面的是控件的格式,如果我只想选到月,sql应该怎么该呀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_DATEFROM STG_SG_LOW_PRICE_MONITORING_DETAIL TWHERE 1=1${if(len(P_PERIOD_NAME) == 0,""," AND MR_DATE =to_date('" + P_PERIOD_NAME + "','yyyy-mm-dd')")}ORDER BY MR_DATE,BUSINESS_UNIT,CUSTOMER_TYPE DESC