오라클에 DATE 타입으로 INSERT / SELECT 하기

INSERT

//오늘날짜 자동입력 (sysdate)

insert into sale_plan values('1309094885','S12011','xxxxxx',5,25000000,'1/4','1234',sysdate); 

//기타 포맷형식으로 입력

insert into sale_plan values('1309094885','S12011','xxxxxx',5,25000000,'1/4','1234',to_date('09-09-2013 12:14:11','mm-dd-yyyy hh24:mi:ss')); 

SELECT

//포맷에 맞춰서 출력하기

select to_char(writerdate, 'yyyy-mm-dd hh24:mi:ss') from sale_plan;

출처 http://blog.naver.com/xerosda?Redirect=Log&logNo=30152191344