SQL Server determines whether time is within a certain time interval

IF EXISTS(SELECT TOP 1 *  fromSys.objectsWHEREName=N'uf_isrange_date'  and [type]='FN')    DROP FUNCTIONuf_isrange_dateGOSETAnsi_nulls onGOSETQuoted_identifier onGO-- =============================================--Author:hehai--Create date:2015-11-19 11:01:01--Description: Determines whether the time is within the time range. -- =============================================CREATE FUNCTIONUf_isrange_date (@date DATETIME,--Time    @date_Range_min DATETIME,--time interval (starting value)    @date_Range_max DATETIME        --time interval (end value))RETURNS BIT asBEGIN    DECLARE @return BIT        SELECT @return=1  fromSys.objectsWHERE @date between @date_Range_min  and @date_Range_max    IF @return  is NULL SET @return=0    RETURN @return --@min_seconds >0 and @max_seconds >0ENDGO--SELECT dbo.uf_isrange_date (' 2015-11-19 ', ' 2015-11-19 ', ' 2015-11-10 ')DECLARE @date DATETIME=N'2015-11-19 10:10:10'DECLARE @date_Range_min DATETIME=N'2015-11-19 10:10:09'DECLARE @date_Range_max DATETIME=N'2015-11-19 10:10:10'SELECTDbo.uf_isrange_date (@date,@date_Range_min,@date_Range_max)

SQL Server determines whether time is within a certain time interval