oracle获得当前时间的,精确到毫秒 可以指定精确豪秒的位数
select to_char(systimestamp, 'yyyymmdd hh24:mi:ss.ff ') from dual;--20120516 11:56:40.729083
select to_char(systimestamp, 'yyyymmdd hh24:mi:ss.ff3') from dual;--20120516 11:58:42.755
desc ct_cdr_comparison
名称 空值 类型
--------------------------- -------- -------------
DATTCDRCOMPARISONGUID NOT NULL TIMESTAMP(9)
VC2CUSTOMER VARCHAR2(200)
VC2M800 VARCHAR2(200)
NUMSTATE NUMBER(1)
NUMMARGINCALLTIME_MIN NUMBER(10)
NUMMARGINCBEGIN_MIN NUMBER(10)
NUMCDR_COMPARISONDETAILGUID NUMBER(10)
DATCREATEADATE DATE
DATOPERATEDATE DATE
VC2CREATECODE VARCHAR2(200)
VC2OPERECODE VARCHAR2(200)
VC2REMARK VARCHAR2(200)
select * from ct_cdr_comparison;
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
如果结果没显示:请设置时间戳
工具==》选项==》数据库==》NLS
时间戳格式:YYYY-MM-DD HH24:MI:SS.FF
insert into ct_cdr_comparison
( dattCDRCOMPARISONGUID,
VC2CUSTOMER,
VC2M800,
NUMSTATE,
NUMMARGINCALLTIME_MIN,
NUMMARGINCBEGIN_MIN,
NUMCDR_COMPARISONDETAILGUID,
DATCREATEADATE,
vc2createcode
)
values (systimestamp,'a','m800',0,20,20,2,sysdate,'liuwen');
出处:http://thinktothings.iteye.com/blog/1532584