获取某年某月的第一天和最后一天的Sql Server函数

1. SET ANSI_NULLS ON
2. GO
3. SET QUOTED_IDENTIFIER ON
4. GO
5. -- =============================================
6. -- Author: RickyLin
7. -- Create date: 2007-11-27
8. -- Description: 获取某年某月的第一天的日期
9. -- =============================================
10. ALTER FUNCTION fnGetFirstDayOfMonth
11. (
12. @Year SMALLINT
13. , @Month TINYINT
14. )
15. RETURNS SMALLDATETIME
16. AS
17. BEGIN
18. DECLARE @FirstDay SMALLDATETIME
19. DECLARE @Str VARCHAR(10)
20. SET @Str = Cast(@Year AS VARCHAR(4)) + '-' + Cast(@Month AS VARCHAR(2)) + '-1'
22. SET @FirstDay = Convert(SMALLDATETIME, @Str)
24. RETURN @FirstDay
26. END
27. GO
29. -- =============================================
30. -- Author: RickyLin
31. -- Create date: 2007-11-27
32. -- Description: 获取某年某月的最后一天的日期
33. -- =============================================
34. CREATE FUNCTION fnGetLastDayOfMonth
35. (
36. @Year SMALLINT
37. , @Month TINYINT
38. )
39. RETURNS SMALLDATETIME
40. AS
41. BEGIN
42. DECLARE @LastDay SMALLDATETIME
43. DECLARE @Str VARCHAR(10)
44. SET @Str = Cast(@Year AS VARCHAR(4)) + '-' + Cast(@Month AS VARCHAR(2)) + '-1'
46. SET @LastDay = DateAdd(d, -1, DateAdd(m, 1, dbo.fnGetFirstDayOfMonth(@Year, @Month)))
48. RETURN @LastDay
50. END
51. GO