´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд


ORACLEÖУº

select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×ֶΠ£¬¶¼ÎªÈÕÆÚÐÍ 


DB2ÖÐÈçºÎʹÓÃдSQL£¬µÃ³öµÄ½á¹ûÓëÉÏÊöÓï¾äÒ»Ö¡£

Çë´óÏÀÃǽâ´ðһϣ¬Ð»Ð»

---

select floor((DAYS(date2)-DAYS(date1))/30) from A;

---

Õâ¸öÒªµ½db2µÄ°æ¿éÀï±È½ÏºÃÎÊÓ´¡£

---

SQL code:
select (year(date2)-year(date1))*12+month(date2)-month(date1) from A

---

ÒýÓÃ

SQL codeselect (year(date2)-year(date1))*12+month(date2)-month(date1)from A

ûÓп¼ÂÇfloorµÄÓ°Ï죬Õâ¸ö ÓеãÎÊÌâµÄ¡£
Èç¹ûÇ°ÕßÈÕÆÚµÄÌìÊý²»µÈÓÚºóÕßÌìÊý£¬ÔÚORACLEÖÐ ¼ÆËãºó½á¹û»áÊÇСÊý£¬¶þ¾­¹ýfloor´¦Àíºó»áÔÚ½á¹ûºóÔÙ-1
¶þÔÙDB2ÀïÃæ ÒòΪ year(date2)-year(date1))*12+month(date2)-month(date1)ÔËËãµÄʼÖÕΪÕûÊý£¬½á¹û»áÓëORACLE²»Í¬

---

ÒýÓÃ

Õâ¸öÒªµ½db2µÄ°æ¿éÀï±È½ÏºÃÎÊÓ´¡£

ºÇºÇ£¬ÄÇÀïµÄÈËÆø±È½ÏµÍ£¬ºÇºÇ

---

ÒýÓÃ

select floor((DAYS(date2)-DAYS(date1))/30) from A;

лл»Ø´ð£¬ºÇºÇ
Õâ¸ö²»Ðеģ¬Ö»ÊǼÆËã³öÁËÌìÊý£¬

¶øÎÒÐèÒªµÄÊÇ ¼ÆËã³öÁ½¸öÈÕÆÚÖ®¼äµÄÔ·ÝÊý¡£²¢ÇÒÒªºÍORACLEÖеĽá¹û±£³ÖÒ»ÖÂ

---

ÒýÓÃ

ÒýÓà 1 Â¥ shiyiwan µÄ»Ø¸´:
select floor((DAYS(