Hi!

How i can store millisec in a TIMESTAMP field?

insert into ANYTABLE (FIELD_X) values (cast ('2005.01.01 11:22:33.123' as TIMESTAMP))

this SQL run successfully, but i cannot read back the milisec value from timestamp.

I try to read fields with borland's dbExpress, and Borland's direct Interbase controls.

The Firebird cannot store millisec or i cannot read back the values? There is any client software, which can show tis values
correctly?

(sorry my english...)

Szak�ly Bal�zs
szoftver fejleszt�
szakalyb@...
www.microraab.hu <http://www.microraab.hu/>
GSM: +36(30)9363639
Tel: +36(96)510738
Fax: +36(96)510719




[Non-text portions of this message have been removed]