add_month等的用法-计算下次生日.docVIP

1. 计算每个人下一次生日的日期2. 判断下次生日在未来90天的 代码: -- 测试表和数据 SQL desc t_person; Name??Type?????????Nullable Default Comments ----- ------------ -------- ------- -------- ID????CHAR(4)??????Y????????????????????????? NAME??VARCHAR2(12) Y????????????????????????? BIRTH DATE?????????Y?????????????????????????  SQL select * from t_person;  ID???NAME?????????BIRTH ---- ------------ ----------- 0001 name_0001????1980-1-1 0002 name_0002????1980-2-1 0003 name_0003????1980-3-1 0004 name_0004????1980-4-1 0005 name_0005????1980-5-1 0006 name_0006????1980-6-1 0007 name_0007????1980-7-1 0008 name_