20 Mar
2007
20 Mar
'07
3:28 p.m.
I am not able to store times with greater precision than milliseconds. ===================== create table ttime2 ( t1 time, t2 time(3), t3 time(6) ); sql>insert into ttime2 more>values ('16:28:14.6411', '16:28:14.6411', '16:28:14.6411'); [ 1 ] sql>select * from ttime2; % sys.ttime2, sys.ttime2, sys.ttime2 # table_name % t1, t2, t3 # name % time, time, time # type % 8, 12, 15 # length [ 16:28:14, 16:28:14.641, 16:28:14.641000 ] ===================== Is this a display issue? It doesn't seem so because I have a primary key defined on another table and the "16:28:14.6411" time fails with a duplicate key.