UFN_TIMEZONEENTRY_GETUTCDATEFROMSYSTEMDEFAULTDATE
Converts a system default date to a UTC date
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SYSTEMDEFAULTDATE | datetime | IN |
Definition
Copy
create function dbo.UFN_TIMEZONEENTRY_GETUTCDATEFROMSYSTEMDEFAULTDATE
(
@SYSTEMDEFAULTDATE as datetime
)
returns datetime
with execute as caller
as begin
declare @TIMEZONEENTRYID uniqueidentifier
declare @UTCOFFSET integer
set @TIMEZONEENTRYID = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULT()
set @UTCOFFSET = dbo.UFN_TIMEZONEENTRY_GETTIMEZONEOFFSETFROMUTC(@TIMEZONEENTRYID, @SYSTEMDEFAULTDATE, 0)
return DATEADD(minute, -1 * @UTCOFFSET, @SYSTEMDEFAULTDATE)
end