SQLʱ¼ä²éѯ

      (CASE WHEN CONVERT(varchar(16), vdatetime2, 120) BETWEEN CONVERT(varchar(100), vdatetime2, 120) + ' 22:59' AND
      CONVERT(varchar(10), vdatetime2, 120) + ' 23:59' THEN CONVERT(varchar(10), vdatetime2 + 1, 120) ELSE CONVERT(varchar(10),
              vdatetime2, 120) END) AS vdatetime21
Çë¸÷λǰ±²°ïæ¸Äһϣ¬ÎÒÒªµÄʱ¼ä·¶Î§ÊÇ£¬±ÈÈç×òÍí23µãµ½Ã÷Ìì5µã£¬¾ÍÊÇ˵ÖÜ5Íí23µãµ½ÖÜÈÕ5µãÕâÑù×Ó

---

ÎÒÏÖÔÚÕâ¸öÄÜʵÏÖ£¬°´ÕÕ×òÍíµÄ23µãµ½½ñÍí23µã
ÎÒÏëÔÙ¼Ó¸öµ½Ã÷Ôç5µã¡£²»ÖªµÀ¿çÌìÔõô²é£¬Çë¸÷λÀÏʦ°ïæ¿´¿´

---

×òÍí23µãµ½Ã÷Ìì5µã
£­£­
CONVERT(varchar(100), vdatetime2, 120) + ' 22:59'  --23µã

CONVERT(varchar(100), vdatetime2+1, 120) + ' 05:59' --µÚ¶þÌì5µã

---

SQL code:

where vdatetime2 between convert(varchar(10),dateadd(day,-1,vdatetime2),120)+' 23:00:00' and
convert(varchar(10),dateadd(day,1,vdatetime2),120)+' 05:00:00'

---

ÒýÓÃ

SQL codewhere vdatetime2betweenconvert(varchar(10),dateadd(day,-1,vdatetime2),120)+' 23:00:00'andconvert(varchar(10),dateadd(day,1,vdatetime2),120)+' 05:00:00'

ÀÏʦÄÜд³ÉÏñÎÒÕâÖÖ¸ñʽô£¿ (CASE WHEN CONVERT(varchar(16), vdatetime2, 120) BETWEEN CONVERT(varchar(100), vdatetime2, 120) + ' 22:59' AND