Saturday, 25 January 2014

CONVERT MONTH-YEAR FORM TO DATE FORMAT

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

No comments:

Post a Comment