Show those employees details who have been hired in the leap day(19th Feb) of any leap year

SELECT *

FROM employees

WHERE DAY(HIRE_DATE)=19 AND ( (YEAR(HIRE_DATE) MOD 4 = 0 )

AND ((YEAR(HIRE_DATE) % 100 != 0) OR (YEAR(HIRE_DATE) % 400 = 0)) );