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'
'Library > SQL' 카테고리의 다른 글
[ORACLE] MAX, ROW인 행 조회하기 (0) | 2023.08.11 |
---|---|
[SQL] SELECT 1 FROM <TABLE> (0) | 2023.08.03 |
[SQL] WHERE 1 = 1 (0) | 2023.08.03 |
[ORACLE] CONNECT BY(계층형 조회) (0) | 2023.06.15 |
댓글