Back to OIM Explorer

dbo.QBM_FGICmp_DateWithinNextDays

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL14 lines
1CREATE FUNCTION dbo.QBM_FGICmp_DateWithinNextDays(2  @Value datetime,3  @days int4) RETURNS BIT5  WITH SCHEMABINDING6AS7BEGIN8  RETURN(CASE9  WHEN coalesce(@Value, '1899-12-30') > '1900-01-01' AND coalesce(@Value, '1899-12-30') <= DateAdd(dd, @days,10  GetUTCDate()) THEN11  112  ELSE 013  END)14END
Open raw exported source
SQL ยท Raw3 lines
1       create   function dbo.QBM_FGICmp_DateWithinNextDays( @Value datetime , @days int ) returns bit with SCHEMABINDING as begin return ( case 2when coalesce(@Value, '1899-12-30') > '1900-01-01' and coalesce(@Value, '1899-12-30') <= DateAdd(dd, @days, GetUTCDate()) then 1 else 0 end ) end 3