hay77772000 wrote:

> I want to insert the current time, including milliseconds, when I
> insert a record.
>
> I am using cast('now' AS Timestamp), but the milliseconds seem to
> all be 0's!
>
> How can I do this in Firebird?

Similar question has been asked recently. Look in archives for a reply
by Helen Borrie dated: 04. Sep 2003.

The subject was: How to retrieve milliseconds?


HTH

--
Milan Babuskov
http://fbexport.sourceforge.net