UFN_TIMEZONEENTRY_GETBASETIMEZONEOFFSETFROMSYSTEMDEFAULT

create function dbo.UFN_TIMEZONEENTRY_GETBASETIMEZONEOFFSETFROMSYSTEMDEFAULT()
returns int
with execute as caller as
begin
       declare @BASETIMEZONEOFFSET int

       select top 1 
              @BASETIMEZONEOFFSET = t.BASETIMEZONEOFFSET
       from
              dbo.INTERNATIONALIZATIONINFO i 
              inner join dbo.TIMEZONEENTRY t on i.DEFAULTTIMEZONEENTRYID = t.ID            

       if @BASETIMEZONEOFFSET is null
              select @BASETIMEZONEOFFSET = BASETIMEZONEOFFSET from dbo.TIMEZONEENTRY where NAME = 'Eastern Standard Time';      

       return @BASETIMEZONEOFFSET
end