SQLÓï¾ä - Oracle / ¿ª·¢

sql,´Ó½ñÌìÆðÏÔʾ³ö±íÒ»ÖÐ15ÌìÄÚÈ˵ÄÉúÈÕ¡£ÒªÇó¸ÃÓï¾äÈκÎÔ·ݶ¼¿ÉʹÓÃ×¢Òâ¿çÄêÒ²¿ÉʹÓÃ
¼±Óã¬ÏÈл¹ýÁË£¬

---

±íÒ»¼Ç¼µÄÉúÈÕÊÇʲôÊý¾Ý£¿³öÉúÄêÔÂÈÕ£¿

---

select birthday from your_tab where birthday >= trunc(sysdate) and birthday <=trunc(sysdate+15);
´Ë´¦µÄbirthdayΪdateÐÍÊý¾Ý£¬Èç¹û²»ÊÇdateÐÍÊý¾Ý£¬Çë×÷ÏàӦת»¯¡£

---

SQL code:
SQL> --½¨±í
SQL> create table birth(id number,birthday date);

±íÒÑ´´½¨¡£

SQL> --²åÈëÊý¾Ý
SQL> insert into BIRTH (ID, BIRTHDAY)
2 values (1, to_date('01-01-1983', 'dd-mm-yyyy'));

ÒÑ´´½¨ 1 ÐС£

SQL> insert into BIRTH (ID, BIRTHDAY)
2 values (2, to_date('25-12-1978', 'dd-mm-yyyy'));

ÒÑ´´½¨ 1 ÐС£

SQL> insert into BIRTH (ID, BIRTHDAY)
2 values (3, to_date('20-02-1983', 'dd-mm-yyyy'));

ÒÑ´´½¨ 1 ÐС£

SQL> insert into BIRTH (ID, BIRTHDAY)
2 values (4, to_date('05-08-1973', 'dd-mm-yyyy'));

ÒÑ´´½¨ 1 ÐС£

SQL> insert into BIRTH (ID, BIRTHDAY)
2 values (5, to_date('16-01-1983', 'dd-mm-yyyy'));

ÒÑ´´½¨ 1 ÐС£

SQL> commit;

Ìá½»Íê³É¡£

SQL> --µ±Ç°ÈÕÆÚ
SQL> select sysdate from dual;

SYSDATE
-------------------
2010-12-24 22:40:42

SQL> --²éѯ15ÌìÄÚÉúÈÕ
SQL> SELECT *
2 from birth t
3 WHERE to_date(to_char(t.birthday, 'mmdd'), 'mmdd') BETWEEN SYSDATE AND
4 trunc(SYSDATE) + 15
5 OR add_months(to_dat