uses DateUtils; //for Delphi6function DaysInAMonth(const AYear, AMonth: Word): Word; //for Delphi5
begin
Result := MonthDays[(AMonth = 2) and IsLeapYear(AYear), AMonth];
end;
begin
Result := MonthDays[(AMonth = 2) and IsLeapYear(AYear), AMonth];
end;
begin
Result := MonthDays[(AMonth = 2) and IsLeapYear(AYear), AMonth];
end;
//or
function DaysInAMonth(const AYear, AMonth: Word): Word;
begin
case AMonth of
1, 3, 5, 7, 8, 10, 12: Result := 31;
2: if IsLeapYear(AYear) then
Result := 28
else Result := 29;
else Result := 30;
end;
Result := MonthDays[(AMonth = 2) and , AMonth];
end;
@test_month char(6)
select datediff(day,cast((@test_month+'01') as datetime),dateadd(month,1,cast((@test_month+'01') as datetime)))