Skip to content

Instantly share code, notes, and snippets.

@kimki1124

kimki1124/oracle_09_03.sql

Created March 8, 2017 12:32
Show Gist options
  • Save kimki1124/dd7142b996ad9ab044459251ed1cdb1f to your computer and use it in GitHub Desktop.
Save kimki1124/dd7142b996ad9ab044459251ed1cdb1f to your computer and use it in GitHub Desktop.
Download ZIP
[ORACLE] SQL 함수 (날짜 함수, 변환 함수, NULL 관련 함수, 기타 함수)
Raw
oracle_09_03.sql
SELECT MONTHS_BETWEEN(SYSDATE, ADD_MONTHS(SYSDATE, 1)) MON1,
MONTHS_BETWEEN(ADD_MONTHS(SYSDATE, 1), SYSDATE) MON2
FROM DUAL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment