设置 Oracle 日期格式
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
alter session set nls_timestamp_format='yyyy-mm-dd hh24:mi:ss';
----------------------------------------------------
导出的SQL语句格式
----------------------------------------------------
Insert into TESTDB.T_ROLE (ROLE_ID,ROLE_NAME,CREATE_DATE,UPDATE_DATE) values (22072011979631,'R_1331884479810',to_timestamp('2002-12-18 23:33:09','yyyy-mm-dd hh24:mi:ss'),to_date('2002-12-18 00:00:00','yyyy-mm-dd hh24:mi:ss'));
---------------------------------------------------
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
---------------------------------------------------
