UFN_MONTHDAY_GETFROMDATE
Return
| Return Type |
|---|
| UDT_MONTHDAY |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SOURCEDATE | datetime | IN |
Definition
Copy
create function dbo.UFN_MONTHDAY_GETFROMDATE
(
@SOURCEDATE datetime
)
returns UDT_MONTHDAY
with execute as caller
as begin
return right('00' + cast(month(@SOURCEDATE) as nvarchar), 2) + right('00' + cast(day(@SOURCEDATE) as nvarchar), 2)
end