티스토리 뷰


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

댓글
댓글쓰기 폼