Oracle时间戳精确到毫秒(oracle9.5以上支持到毫秒)
/*我自己需要*/
1.
select to_char(systimestamp,'yyyymmddhh24missff2') from dual;
网上down
2.
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;
/*我自己需要*/
1.
select to_char(systimestamp,'yyyymmddhh24missff2') from dual;
网上down
2.
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;