날짜 함수(복습필요)

8.날짜 함수

기본날짜표시 형식은 DAY-MON-YEAR

 

ex)

select SYSDATE(날짜 및 시간을 반환하는 함수)

from dual;

 

select last_name,

round((sysdate-hire_date)/ 7, 1) as emp_week

from employees

where department_id = 80;

 

select last_name, hire_date,

round(hire_date,'MONTH') as rnd-mon

from employees

where department_id = 80;