Need a function

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Fri, 30 Oct 1998 06:59:40 GMT
Message-ID: <363d63d5.6763515@news.twsc.pouchen.com.tw>

Hello,
I have to create a procedure:
CREATE PROCEDURE TEST (start_date IN VARCHAR2,

                                                           end_date IN VARCHAR2)

If the start_date is the first day of the month and

   the end_date is the last day of the month    ex.start_date='19981001' and end_date='19981031' Then return the first day of last month and

                       the end day of last month.
           return '19980901' and '19980930'.
   

I want to know is there any function to verify if the end_date is the last day of the month. or how to create a function for the purpose.

Thank you for your help.
Please Cc to: violin.hsiao_at_mail.popuchen.com.tw,Thanks.

Violin. Received on Fri Oct 30 1998 - 00:59:40 CST