CONVERT MONTH-YEAR FORM TO DATE FORMAT
select trunc(trunc(to_date(:p_from_month,'Mon-YYYY'),'MM'),'MM') ,last_day(to_date(:p_to_month,'Mon-YYYY')) from dual
select trunc(trunc(to_date(:p_from_month,'Mon-YYYY'),'MM'),'MM') ,last_day(to_date(:p_to_month,'Mon-YYYY')) from dual
No comments:
Post a Comment