1901 碎片化 (1 / 14)
        y_mask & DATEPART(dw, GETDATE ()) > 0) -- potentially in outage window

         BEGIN

         SELECT @cur_time = DATEPART (hh, GETDATE()) * 10000 +

         DATEPART (mi, GETDATE()) * 100 +

         DATEPART (ss, GETDATE())

         -- outage doesn't span midnight

         IF (@outage_start_time < @outage_end_time)

         BEGIN

         IF (@cur_time >= @outage_start_time AND @cur_time < @outage_end_time)

         RETURN(1) -- in outage

         END

         -- outage does span midnight

         ELSE IF (@outage_start_time > @outage_end_time)

         BEGIN

  The content is not finished, continue reading on the next page

更多完整内容阅读登陆

《墨缘文学网，https://wap.mywenxue.org》