ÓÅ»¯SQLÓï¾ä

¸Õ¿ªÊ¼Ñ§Ï°SQL,ÏÂÃæµÄÓï¾äÓÐûÓиüºÃµÄ·½·¨Ñ½

SQL code:
DECLARE @Now datetime SET @Now = GETDATE() DECLARE @rqbc varchar(10) SET @rqbc = CONVERT(varchar(10), DATEADD(mi, - (SELECT StartDay from Parameter), @Now), 120)
SELECT CONVERT(varchar(19), @Now, 120) AS sj
, CONVERT(varchar(10), @Now, 120) AS rq
, @rqbc AS rqbc
, CASE WHEN CONVERT(varchar(8), @Now, 108) >= '08:30:00' AND CONVERT(varchar(8), @Now, 108) < '19:30:00' THEN '°×°à' ELSE 'Ò¹°à' END AS bc
, CONVERT(varchar(10), DATEADD(mm, DATEDIFF(mm, 0, @rqbc), 0), 120) AS yf

---

CASE WHEN CONVERT(varchar(8), @Now, 108) >= '08:30:00' AND CONVERT(varchar(8), @Now, 108) < '19:30:00' THEN '°×°à' ELSE 'Ò¹°à' END AS bc

·µ»Ø°à´Î°´ÕÕÏÂÁбíÖÐʱ¼ä¶Î·µ»ØÈçºÎ×öѽ£¿
¿ªÊ¼Ê±¼ä      ½áÊøʱ¼ä    °à´Î
07:30:00    16:30:00    Ò»°à
16:30:00    24:00:00    ¶þ°à
24:00:00    07:30:00    Èý°à

---

ÎÒ×Ô¼ºÐ´µÄ£¬»¹Óкõķ½·¨Âð£¿
SQL code:
DECLARE @Now datetime SET @Now = GETDATE() DECLARE @rqbc varchar(10) SET @rqbc = CONVERT(varchar(10), DATEADD(mi, - (SELECT StartDay from LSY_Parameter), @Now), 120)
SELECT CONVE