我现在查询生日为2月8日的人的信息而不管他是几几年出生的,可是我执行以下的SQL语句却只能查询今年的
SELECT USERID, DEPTID, TO_CHAR( BIRTYDAY,'YYYY/MM/DD') FROM ZHOUX_NEWTODO WHERE DEPTID = 2073 AND ( BIRTYDAY LIKE TO_DATE('02/08','MM/DD') )
请各位高手指点一下
SELECT USERID, DEPTID, TO_CHAR( BIRTYDAY,'YYYY/MM/DD') FROM ZHOUX_NEWTODO WHERE DEPTID = 2073 AND ( BIRTYDAY LIKE TO_DATE('02/08','MM/DD') )
请各位高手指点一下
FROM ZHOUX_NEWTODO WHERE DEPTID = 2073 AND TO_Char(Birthday,'mm/dd')='02/08'
FROM ZHOUX_NEWTODO
WHERE DEPTID = 2073
AND TO_Char(Birthday,'mm/dd')='02/08'
和
SELECT USERID, DEPTID, TO_CHAR( BIRTYDAY,'YYYY/MM/DD') BIRTYDAY
FROM ZHOUX_NEWTODO
WHERE DEPTID = 2073
AND SUBSTR(TO_CHAR(BIRTYDAY,'yyyymmdd'),5)='0208'
也可以
TO_CHAR(BIRTYDAY,'MMDD') = TO_CHAR(SYSDATE,'MMDD')
WHERE DEPTID = 2073 AND to_char(BIRTYDAY, 'mmdd') = '0208'