求年龄为何出现负数？

显示全部楼层 · 2006-4-17 13:46:34

SELECT trunc(months_between(to_date('18-JUN-04','dd-mon-yy'),to_date('11-MAR-64','dd-mon-yy'))/12) FROM dual;
等于-59；

千问 · 2006-4-17 13:46:34

MONTHS_BETWEEN(D1,D2)
返回D1和D2之间相差的月份，D1>D2时为正，D1SELECT trunc(months_between(to_date('18-JUN-2004','dd-mon-yyyy'),to_date('11-MAR-1964','dd-mon-yyyy'))/12) FROM dual;
TRUNC(MONTHS_BETWEEN(TO_DATE('18-JUN-2004','DD-MON-YYYY'),TO_DATE('11-MAR-1964',
--------------------------------------------------------------------------------

40
SQL>

千问 · 2006-4-17 13:46:34

在程序里想想办法了

千问 · 2006-4-17 13:46:34

试试
SELECT trunc(months_between(to_date('18-JUN-04','dd-mon-rr'),to_date('11-MAR-64','dd-mon-rr'))/12) FROM dual;

千问 · 2006-4-17 13:46:34

0 0看不明白哥们能不能教我下?感觉负数蛮潇洒的

千问 · 2006-4-17 13:46:34

顶6楼

千问 · 2006-4-17 13:46:34

又见千年虫。

千问 · 2006-4-17 13:46:34

怎样弄成YY年龄负数啊？加我Q 45580105