Back to OIM Explorer

dbo.QBM_FCVDatetimeLocalToUTC

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 528 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

SQL29 lines
1CREATE FUNCTION dbo.QBM_FCVDatetimeLocalToUTC(2  @DatetimeLocal datetime,3  @timezone varchar(64)4) RETURNS datetime5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @v varchar(64)9  DECLARE @mi int10  DECLARE @tz varchar(5)11  SELECT12    @v = convert(varchar,13    convert(datetime, @DatetimeLocal, 121) at time zone @timezone,14    121)15  SELECT @tz =16  RIGHT(@v,17  6)18  SELECT19    @mi = convert(int,20    substring(@tz, 2, 2)) *60 + convert(int,21    substring(@tz, 5, 2))22  IF23  LEFT(@tz,24  1) <> '-'25  BEGIN26    SELECT @mi = 0 - @mi27  END28  RETURN(dateadd(mi, @mi, @DatetimeLocal))29END
Open raw exported source
SQL ยท Raw5 lines
1  create   function dbo.QBM_FCVDatetimeLocalToUTC( @DatetimeLocal datetime , @timezone varchar(64)  ) returns datetime with SCHEMABINDING as begin2 declare @v varchar(64) declare @mi int declare @tz varchar(5)  select @v = convert(varchar, convert(datetime, @DatetimeLocal, 121) at time zone @timezone3, 121) select @tz = right(@v, 6) select @mi = convert(int, substring(@tz, 2,2))*60 + convert(int, substring(@tz, 5,2)) if left(@tz, 1) <> '-' begin  select4 @mi = 0 - @mi end  return(dateadd(mi, @mi, @DatetimeLocal)) end 5