Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- alter function FullDayy
- (
- @date1 date,
- @date2 date
- )
- returns int
- as
- begin
- declare @pom int
- declare @god int
- declare @mes int
- select @god = dbo.FullYear(@date1, @date2)
- select @mes = dbo.FullMonth(@date1, @date2)
- select @date1 = DATEADD(YEAR, @god, @date1)
- select @date1 = DATEADD(month, @mes, @date1)
- select @pom = datediff(month, @date1, @date2)
- if(DATEADD(month, @pom, @date1)>@date2)
- set @pom = @pom-1
- return @pom
- end
- create function FullMonth
- (
- @date1 date,
- @date2 date
- )
- returns int
- as
- begin
- declare @pom int
- declare @god int
- select @god = dbo.FullYear(@date1, @date2)
- select @date1 = DATEADD(YEAR, @god, @date1)
- select @pom = datediff(month, @date1, @date2)
- if(DATEADD(month, @pom, @date1)>@date2)
- set @pom = @pom-1
- return @pom
- end
- create function FullYear
- (
- @date1 date,
- @date2 date
- )
- returns int
- as
- begin
- declare @pom as int
- select @pom = DATEDIFF(YEAR, @date1, @date2)
- if(DATEADD(YEAR, @pom, @date1)> @date2)
- set @pom = @pom-1
- return @pom
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement