Re: Date function
From: Chris Colclough <chris.colclough_at_nospam.jhuapl.edu>
Date: 1998/04/07
Message-ID: <352A3C64.DFDBB358_at_nospam.jhuapl.edu>#1/1
Date: 1998/04/07
Message-ID: <352A3C64.DFDBB358_at_nospam.jhuapl.edu>#1/1
Try:
select to_number(to_char(last_day(to_date('&mm/&yyyy','mm/yyyy')),'dd'))
from dual
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