> I'm trying the following sentence in Interbase 6
>
> update testtable set testdate = '2003-01-01 07:00:00.120'
>
> and it works, except that it ignores the
> milliseconds.
>
> To read the results I use a Delphi application,
> and milliseconds are always set to 0.
>
> The same with IBConsole.

InterBase stores seconds with four decimal places.
If you do not see correct result, it is the formatting problem
of the application you are using, not InterBase.

Either try the same command with ISQL (do not forget to SET TIME ON;),
or do the formatting directly on the server, i.e.
SELECT CAST(testdate AS VARCHAR(25)) FROM testtable;

Ivan
http://www.volny.cz/iprenosil/interbase