오라클 함수정리 3탄 (단일함수)
SELECT DEPARTMENT_ID FROM EMPLOYEES WHERE UPPER(department_id) = 80; SELECT TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS') FROM DUAL;--SYSDATE(현재날짜) 24가없으면 12시간 24가 있으면 24시제 -, /(문자열 표시) SELECT TO_CHAR(SYSDATE,'D') AS D , TO_CHAR(SYSDATE,'DAY') AS DAY , TO_CHAR(SYSDATE,'DD') AS DD , TO_CHAR(SYSDATE,'DY') AS DY , TO_CHAR(SYSDATE,'HH') AS HH , TO_CHAR(SYSDATE,'HH24') AS HH24 , TO_CHAR(SYSDATE,'MI') AS ..
더보기