UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC
Converts a UTC date to a system default date
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @UTCDATE | datetime | IN |
Definition
Copy
create function dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC
(
@UTCDATE 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, @UTCDATE, 1)
return DATEADD(minute, @UTCOFFSET, @UTCDATE)
end