sqlÈÕÆÚ²éѯ

sql ²éѯ£¬»ñÈ¡½ñÌìÁ賿0µãµ½ÏÖÔÚΪֹµÄʱ¼ä£¨²»ÊÇ»ñÈ¡µ±Ç°ÏµÍ³Ê±¼ä£©

---

ʲôÒâ˼£¬ËµÃ÷°×µã

---

»ñÈ¡µ±Ììʱ¼ä£¬Áãµãµ½ÏÖÔÚµÄʱ¼ä

---

ʲôÒâ˼

---

Òª»ñȡʱ¼ä²î£¿

---

ËûµÄÒâ˼ÊÇÇó³ö¾ßÌåÊǼ¸µã

---

»ñÈ¡½ñÌìÁ賿0µãµ½ÏÖÔÚΪֹµÄʱ¼ä?ÄãÊÇÏëҪʲô£¬ÒªÊ±¼ä²îÂ𣿻¹ÊÇÒª´Ó0µãµ½µ±Ç°µÄÿ¸öʱ¼ä×Ö·û´®

---

select DATEPART(hour, getdate()) µ±Ç°ÊǼ¸µã¡£¡£¡£

---

²»ÊÇ£¬ÊÇ»ñÈ¡£¬½ñÌì0µãµ½ÏÖÔÚʱ¼äµÄÕâ¶Îʱ¼ä£»±ÈÈ磨0µã-10µã£©

---

SQL code:
--ÒѾ­¹ýÁ˼¸Ð¡Ê±
SELECT Cast(DATEPART(hour, GETDATE()) As varchar(2)) + 'Сʱ' + Cast(DATEPART(n, GETDATE()) As varchar(2)) + '·ÖÖÓ' + Cast(DATEPART(s, GETDATE()) As varchar(2)) + 'Ãë'

---

SELECT Cast(DATEPART(hour, GETDATE()) As varchar(2)) + 'Сʱ' + Cast(DATEPART(n, GETDATE()) As varchar(2)) + '·ÖÖÓ' + Cast(DATEPART(s, GETDATE()) As varchar(2)) + 'Ãë'

---

9 10Â¥Ó¦¸ÃÕý½â

---

ÒýÓÃ

SQL code--ÒѾ­¹ýÁ˼¸Ð¡Ê±SELECTCast(DATEPART(hour,GETDATE())Asvarchar(2))+'Сʱ'+Cast(DATEPART(n,GETDATE())Asvarchar(2))+'·ÖÖÓ'+Cast(DATEPART(s,GETDATE())Asvarchar(2))+'Ãë'

Õý½â£¡

---

http://hi.baidu.com/silence_qin/blog/item/5d624a0a0c05ae1595ca6bc8.html

---

http://hi.baidu.com/silence_qin/blog/item/5d624a0a0c05ae1595ca6bc8.html

---

2009-12-09 09:34:00.000 ÎÒÒªµÄ¸ñʽÊÇÕâÑùµÄ