Re: Determining the Total Number of Days in a Month

[David Donnelly <Dave@ISISBIO.COM>]

Well, in Oracle,

        select last_day(any_date_field) from dual;

of course, if you've got it in character format, that'd be

        select last_day(to_date(any_date_field)) from dual;

with format information if necessary.

and if your database doesn't have last_day but does have day_before, you can 
look for the day part of the day before the first of the next month (mod 12, of 
course)....



At 05:33 PM 9/11/2000 -0500, you wrote:
>Does any one have an easy way to determine the total of days are in a given
>month?
>
>Thanks for your help.
>Dave Benzenhafer


Dave Donnelly           <dave@isisbio.com>
ISIS BioComp            phone (909) 677-2446      fax (781) 207-5533