SQLÎÊÌâ ¼ÆËãÒ»¶Îʱ¼äÌìÊýÎÊÌâ

ÀýÈ磺1999-12-21µ½2000-3-15Ö®¼äÓжàÉÙÌì¡£ 
±¾È˸ÕѧSQL£¬×îºÃÄÜÏêϸµã£¬Ð»Ð»£¡£¡£¡

---

datediff ʱ¼äº¯Êý£¬×îºÃ¿´¿´Áª»ú°ïÖú¡£

---

datediff(day,begindate,enddate)

---

SQL code:

select datediff(dd,'1999-12-21','2000-3-15')

/**

-----------
85

£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©

**/

---

DATEDIFF (Transact-SQL)
·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆڱ߽çÊýºÍʱ¼ä±ß½çÊý¡£
http://technet.microsoft.com/zh-cn/library/ms189794%28SQL.90%29.aspx

---

¿´°ïÖú°É 
Ö±½ÓÓÃdatediff º¯Êý ¼ÆËã2¶Îʱ¼äÏà²îÌìÊý
select datediff(day,¿ªÊ¼Ê±¼ä£¬½áÊøʱ¼ä)

---

ÒýÓÃ

SQL codeselectdatediff(dd,'1999-12-21','2000-3-15')/**

-----------
85

£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©

**/

..............

---

select ceil((To_date('2000-3-15' , 'yyyy-mm-dd') -
            To_date('1999-12-21' , 'yyyy-mm-dd')))
from DUAL

---

來ÍíÁË

---

SQL code:

select datediff(day,'1999-12-21','2000-3-15')

---

select datediff(d,'1999-12-21','2000-3-15') as ÌìÊý

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighte