A scalar function to get Last Day of the month.
CREATE FUNCTION LastDayInMonth (@when DATETIME)
RETURNS INT
AS
BEGIN
Declare @lastDate int
SELECT @lastdate = DAY(DATEADD(DAY,-1,DATEADD(MONTH,1,DATEADD(DAY,1-DAY(@when),@when))))
RETURN @lastDate
End
-- Invoking the function
SELECT dbo.LastDayInMonth(Getdate())
SELECT dbo.lastDayInMonth('02/02/2007')
|
| Author: Kapil Dhawan 18 Jun 2008 | Member Level: Gold Points : 2 |
Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you
Regards,
Kapil
|
| Author: Bunty 20 Jun 2008 | Member Level: Diamond Points : 1 |
Hi,
Good code.
Nice way to use function in SQL Server.
Keep posting.
Regards
Satyanarayan
|
| Author: Gunarathinam.M 01 Jul 2008 | Member Level: Gold Points : 2 |
Create FUNCTION dbo.LastDayInMonth (@when DATETIME)
RETURNS INT
AS
BEGIN
Declare @lastDate Datetime
set @lastdate = convert(datetime,convert(char,month(@When))+ '-01-' + convert(char,year(@when)))
set @lastdate = dateadd(day,-1,dateadd(month,1,@lastDate))
RETURN day(@lastDate)
End
Try this.
|