@H_4040@<span style="color: #ff0000">

oracle获得当前时间的，精确到毫秒 可以指定精确豪秒的位数

@H404_0@select tochar(systimestamp,'yyyymmdd hh24:mi:ss.ff ') from dual;--20120516 11:56:40.729083

@H404_0@select tochar(systimestamp,'yyyymmdd hh24:mi:ss.ff3') from dual;--20120516 11:58:42.755

@H404_0@

desc ct_cdrcomparison

@H404_0@名称 空值 类型

--------------------------- -------- -------------

DATTCDRCOMPARISONGUID NOT NULL TIMESTAMP(9)

VC2CUSTOMER VARCHAR2(200)

VC2M800 VARCHAR2(200)

NUMSTATE NUMBER(1)

NUMMARGINCALLTIME_MIN NUMBER(10)

NUMMARGINCBEGIN_MIN NUMBER(10)

NUMCDRCOMPARISONDETAILGUID NUMBER(10)

DATCREATEADATE DATE

DATOPERATEDATE DATE

VC2CREATECODE VARCHAR2(200)

VC2OPERECODE VARCHAR2(200)

VC2REMARK VARCHAR2(200)

@H404_0@

select * from ct_cdrcomparison;



2012-05-16 13:17:14.340213000 a m800 0 20 20 1 2012-05-16 13:17:14 liuwen

2012-05-16 13:19:36.659724000 a m800 0 20 20 2 2012-05-16 13:19:36 liuwen

@H404_0@

<span style="color: #ff00ff">如果结果没显示：请设置时间戳

@H_404_0@工具==》选项==》数据库==》NLS

@H_404_0@时间戳格式：

<span style="background-color: #ccffcc">YYYY-MM-DD HH24:MI:SS.FF

<div class="jb51code">
<pre class="brush:xhtml;">
insert into ct_cdr_comparison
( dattCDRCOMPARISONGUID,VC2CUSTOMER,VC2M800,NUMSTATE,NUMMARGINCALLTIME_MIN,NUMMARGINCBEGIN_MIN,NUMCDR_COMPARISONDETAILGUID,DATCREATEADATE,vc2createcode
)
values (systimestamp,'a','m800',20,2,sysdate,'liuwen');