오라클 DB SQL 교육 정리 (중급)
1.날짜처리 select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') from dual; select trunc(months_between(sysdate,to_date('19970101','yyyymmdd'))/12) "년", trunc(months_between(sysdate,to_date('19970101','yyyymmdd'))- trunc(months_between(sysdate,to_date('19970101','yyyymmdd'))/12)*12) "개월", trunc(months_between(sysdate,to_date('19970101','yyyymmdd'))- trunc(months_between(sysdate,to_date('19970101','yyyymmd..
더보기