Re: Date function

Victor,

You wanted a number, so put a to_number in front of the original one I sent you, like this:

select to_number(substr(last_day(to_date('NOV-98', 'MON-YY')),1,2)) from dual;

Thanks,
Adrian

Victor Zwimpfer wrote:

> 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 07 1998 - 00:00:00 CEST