计算周岁的sql语句 select trunc(months_between(sysdate,date'1992
step4:最后用where做条件筛选add_months(trunc(sysdate'y,12)
当年第一天:selecttrunc(sysdate'yyyy)fromdual;selecttrunc
add_months(trunc(sysdate'y,12-trunc(sysdate'y from dual
返回指定的值一,截取时间select trunc(sysdate'yyyy from dual