Clean Code that Works.

orcle date format +1

Oracle date format

DataBase2008. 12. 18. 13:03
http://www.oradev.com/oracle_date_format.jsp

select * from v$nls_parameters;

nls_parameters에 값들 보기

ALTER session set nls_date_format='YYYY-MM-DD HH24:MI:SS:FF3';
ALTER session set nls_timestamp_format='YYYY-MM-DD HH24:MI:SS:FF3';

date 형식 수정하기.