Re: Date function
From: Girish Vasu <Girish.Vasu_at_Compaq.com>
Date: 1998/04/14
Message-ID: <01bd67e3$e98fe280$301012ac_at_girishvasu>#1/1
30-APR-98 select last_day('02-FEB-98') from dual;
28-FEB-98 Victor Zwimpfer <vzwimpfer_at_scope.ch> wrote in article <6gd6ie$hjf$1_at_news.imp.ch>...
> Hi
>
> Is there a Date function that returns me the maximum number of days of
the
> month, if i know the month and the year.
> Example:
>
> March: 31 days
> April: 30 days
> February: 28/29 days, dependign if it is a leap year or not.
>
> Thank you
> Victor
> vzwimpfer_at_scope.ch
>
>
>
Received on Tue Apr 14 1998 - 00:00:00 CEST
Date: 1998/04/14
Message-ID: <01bd67e3$e98fe280$301012ac_at_girishvasu>#1/1
Yes
Use last_day(date)
eg:
select last_day(sysdate) from dual;
LAST_DAY(
30-APR-98 select last_day('02-FEB-98') from dual;
LAST_DAY(
28-FEB-98 Victor Zwimpfer <vzwimpfer_at_scope.ch> wrote in article <6gd6ie$hjf$1_at_news.imp.ch>...
> Hi
>
> Is there a Date function that returns me the maximum number of days of
the
> month, if i know the month and the year.
> Example:
>
> March: 31 days
> April: 30 days
> February: 28/29 days, dependign if it is a leap year or not.
>
> Thank you
> Victor
> vzwimpfer_at_scope.ch
>
>
>
Received on Tue Apr 14 1998 - 00:00:00 CEST