Re: Need a function

LAST_DAY(d) Returns the last day of the month

Hope this will help you.

Rene

Violin wrote:

> 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 - 05:48:29 CST