Back to OIM Explorer

dbo.QBM_FCVDatetimeUTCToLocal

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 577 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL33 lines
1CREATE FUNCTION dbo.QBM_FCVDatetimeUTCToLocal(2  @DatetimeUTC datetime,3  @timezone varchar(64)4) RETURNS datetime5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @v varchar(64)9  DECLARE @mi int = 010  DECLARE @tz varchar(5)11  IF @DatetimeUTC < '2200-01-01'12  BEGIN13    SELECT14      @v = convert(varchar,15      convert(datetime, @DatetimeUTC, 121) at time zone @timezone,16      121)17    SELECT @tz =18    RIGHT(@v,19    6)20    SELECT21      @mi = convert(int,22      substring(@tz, 2, 2)) *60 + convert(int,23      substring(@tz, 5, 2))24    IF25    LEFT(@tz,26    1) = '-'27    BEGIN28      SELECT @mi = 0 - @mi29    END30  END31  EndLabel:32  RETURN(dateadd(mi, @mi, @datetimeutc))33END
Open raw exported source
SQL ยท Raw5 lines
1   create   function dbo.QBM_FCVDatetimeUTCToLocal( @DatetimeUTC datetime , @timezone varchar(64)  ) returns datetime with SCHEMABINDING as begin2 declare @v varchar(64) declare @mi int = 0 declare @tz varchar(5) if @DatetimeUTC < '2200-01-01' begin select @v = convert(varchar, convert(datetime, 3@DatetimeUTC, 121) at time zone @timezone, 121)  select @tz = right(@v, 6) select @mi = convert(int, substring(@tz, 2,2))*60 + convert(int, substring(@tz4, 5,2)) if left(@tz, 1) = '-' begin  select @mi = 0 - @mi end end  EndLabel: return(dateadd(mi, @mi, @datetimeutc)) end 5