UFN_MONTHDAY_ADDDAYS
This sql function adds the given number of days to a UDT_MONTHDAY value with in the given year.
Return
| Return Type |
|---|
| UDT_MONTHDAY |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MONTHDAY | UDT_MONTHDAY | IN | |
| @YEAR | int | IN | |
| @DAYS | int | IN |
Definition
Copy
create function dbo.UFN_MONTHDAY_ADDDAYS
(
@MONTHDAY as dbo.UDT_MONTHDAY,
@YEAR as integer,
@DAYS as integer
)
returns dbo.UDT_MONTHDAY
with execute as caller
as begin
declare @RESULT as dbo.UDT_MONTHDAY;
declare @TEMP as datetime;
set @TEMP = cast(left(@MONTHDAY,2) + '/' + right(@MONTHDAY,2) + '/' + cast(Year(@YEAR) as nvarchar) as datetime);
set @TEMP = dateadd(day, @DAYS, @TEMP);
set @RESULT = right('00' + cast(Month(@TEMP) as nvarchar), 2) + right('00' + cast(Day(@TEMP) as nvarchar), 2)
return @RESULT;
end