Re: Need a function

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: Fri, 30 Oct 1998 11:44:15 +0100
Message-ID: <71c5g4$cft$1@cbu.pvtnet.cz>

Hi,
you can use the LAST_DAY function:
if LAST_DAY(d) = d then d is the last day of the month, if LAST_DAY(d-1) = d-1 then d is the first day of the month.

Hth,
Pavel

Violin wrote in message <363b5fae.5700847_at_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 - 04:44:15 CST