UFN_GETDATEONLY
It returns the date only removing the datetime portion of the datetime value.
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DateTime | datetime | IN |
Definition
Copy
create function dbo.UFN_GETDATEONLY
(@DateTime DateTime)
-- Returns @DateTime at midnight; i.e., it removes the time portion of a DateTime value.
returns datetime
as
begin
return dateadd(dd,0, datediff(dd,0,@DateTime))
end