문제

* 입사일자에 6개월을 더한 날짜를 2008/01/01 15:00:00 형식으로,

급여를 3,500.00 형식으로 표시하시오.

-->

select to_char(hire_date,'YYYY/MM/DD HH24:MI:SS'), to_char(salary,'99,999,999.99') from employees;

TO_CHAR(HIRE_DATE,'YYYY/MM/DDHH24:MI:SS') TO_CHAR(SALARY,'99,999,999.99') 
2003/06/17 00:00:00      24,000.00 
2005/09/21 00:00:00      17,000.00 
2001/01/13 00:00:00      17,000.00 
2006/01/03 00:00:00       9,000.00 
2007/05/21 00:00:00       6,000.00 
2005/06/25 00:00:00       4,800.00 
2006/02/05 00:00:00       4,800.00 
2007/02/07 00:00:00       4,200.00 
2002/08/17 00:00:00      12,008.00 
2002/08/16 00:00:00       9,000.00