oracle精确到毫秒纳秒

注：sysdate 不带毫秒

oracle9.5以上支持到毫秒

select  to_char(systimestamp,'yyyy-mm-dd hh24:mi:ssxff')  from dual;

select   to_timestamp('2003-10-24  10:48:45.656000','yyyy-mm-dd   hh24:mi:ssxff')   from   dual;

 

纳秒  精度到后9位

INSERT INTO "tablename"("id", "time") VALUES ('2', TO_TIMESTAMP(systimestamp, 'SYYYY-MM-DD HH24:MI:SS:FF9'));

INSERT INTO "yunchuan02"("id", "time") VALUES ('2', TO_TIMESTAMP(systimestamp, 'SYYYY-MM-DD HH24:MI:SS:FF9'));