Re: Need a function

From: Ravinder Reddy Anumula <ranumula_at_cncx.com>
Date: 30 Oct 1998 17:01:36 PST
Message-ID: <363A6170.78BF9731@cncx.com>

If trunc(end_date) = trunc(last_day(end_date)) Then

 ...................

/Ravinder Reddy Anumula(Ravi)

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.

--
-Ravi.

---

Ravinder Reddy Anumula. Ph:408-343-2217(Work) Received on Fri Oct 30 1998 - 19:01:36 CST