Very Computer

I am wanna know about last day of the month, let's assume I will give input
like

select last_day(2002-01-04)

It will return me 31, the last day of the month

Is there any function available in sql server ?

regards
Noor
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Noorali Issani
Database Developer Tel(Off):+92(021)-452-8801(EXT 208)
Tel(Res):+92(021)633-1912

------------------- Visit: My
Resume --------------------------------------------------------------------
Just Believe In YourSelf...every thing will fall in order But dont forget to
pray...Pray as if every thing depends on Allah, and work as if every thing
depends on
you. --------------------------------------------------------------------

Quote:>I am wanna know about last day of the month, let's assume I will give input
>like
>select last_day(2002-01-04)

>It will return me 31, the last day of the month
>Is there any function available in sql server ?

returns int
as
begin

  -- check for leap year

  begin

    begin

    end
  end

    case












      else -1
    end

end

Marc

Quote:> I am wanna know about last day of the month, let's assume I will give
> input like

> select last_day(2002-01-04)

> It will return me 31, the last day of the month

> Is there any function available in sql server ?

This just removes that day, concatenates '01' to reset to the
beginning of the month, adds one month, and subtracts one day.

select dateadd(dd, -1, dateadd(mm, 1,

Linda