Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. alter function FullDayy
  2. (
  3. @date1 date,
  4. @date2 date
  5. )
  6. returns int
  7. as
  8. begin
  9. declare @pom int
  10. declare @god int
  11. declare @mes int
  12.  
  13. select @god = dbo.FullYear(@date1, @date2)
  14. select @mes = dbo.FullMonth(@date1, @date2)
  15.  
  16.  
  17. select @date1 = DATEADD(YEAR, @god, @date1)
  18. select @date1 = DATEADD(month, @mes, @date1)
  19.  
  20. select @pom = datediff(month, @date1, @date2)
  21. if(DATEADD(month, @pom, @date1)>@date2)
  22. set @pom = @pom-1
  23. return @pom
  24. end
  25.  
  26. create function FullMonth
  27. (
  28. @date1 date,
  29. @date2 date
  30. )
  31. returns int
  32. as
  33. begin
  34. declare @pom int
  35. declare @god int
  36.  
  37. select @god = dbo.FullYear(@date1, @date2)
  38. select @date1 = DATEADD(YEAR, @god, @date1)
  39. select @pom = datediff(month, @date1, @date2)
  40. if(DATEADD(month, @pom, @date1)>@date2)
  41. set @pom = @pom-1
  42. return @pom
  43. end
  44.  
  45. create function FullYear
  46. (
  47. @date1 date,
  48. @date2 date
  49. )
  50.  
  51. returns int
  52. as
  53. begin
  54. declare @pom as int
  55. select @pom = DATEDIFF(YEAR, @date1, @date2)
  56. if(DATEADD(YEAR, @pom, @date1)> @date2)
  57. set @pom = @pom-1
  58. return @pom
  59. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement