UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET
Returns a date with time offset of system default for date passed in
Return
| Return Type |
|---|
| datetimeoffset |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATEFOROFFSET | datetime | IN | |
| @DATEISUTC | bit | IN |
Definition
Copy
CREATE function dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET
(
@DATEFOROFFSET as datetime,
@DATEISUTC as bit
)
returns datetimeoffset
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, @DATEFOROFFSET, @DATEISUTC);
if @DATEISUTC = 1
set @DATEFOROFFSET = DATEADD(minute, @UTCOFFSET, @DATEFOROFFSET);
return TODATETIMEOFFSET(@DATEFOROFFSET, @UTCOFFSET);
end