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.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
MonetDB-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-users
