SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Last day of month when year number and month number are given

843414Mar 9 2011 — edited Mar 9 2011

Hi,
When the table has only YR_NO and MO_NO, how can I get the reporting date as last day of the MO_NO concatenated with YR_NO in the format 'MM/DD/YYYY' in Oracle sql ?

Please help

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2011

Added on Mar 9 2011

8 comments

1,092 views