Re: Determining the Total Number of Days in a Month

["Jamadagni, Rajendra" <rajendra.jamadagni@ESPN.COM>]

If you are using oracle .....

select 1+(trunc(last_day(sysdate))- trunc(trunc(sysdate,'MM'))) from dual;

will give you number of days for current month. You can expand on this to
get number of days for any month.

HTH
Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art !
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.