[ORACLE] 년, 월, 일, 시, 분, 초 추출

SELECT COUNT(*)
FROM TABLE1 T1
WHERE 1=1
AND EXTRACT(YEAR FROM T1.INS_DT) = '2023'
AND EXTRACT(MONTH FROM T1.INS_DT) = '8'
AND EXTRACT(DAY FROM T1.INS_DT) = '11'
AND EXTRACT(HOUR FROM CAST(T1.INS_DE AS TIMESTAMP)) = '10'
AND EXTRACT(MINUTE FROM CAST(T1.INS_DE AS TIMESTAMP)) = '3'
AND EXTRACT(SECOND FROM CAST(T1.INS_DE AS TIMESTAMP)) = '30'