On 22 Sep 2004 at 17:47, Erkin ESKIER wrote:

>What is the best way to store miliseconds in Firebird ?
>Something like that : hh:mm:ss.zzzz
>
>Does Firebird DateTime or Time field support this precision ?

Yes and no. Timestamp and Time fields support milliseconds, so you
can store and retrieve them. But some parts of Firebird which use
POSIX 'struct tm' - don't. It is CURRENT_TIMESTAMP, CURRENT_TIME,
CAST() and isc_decode(encode)_timestamp.

>If not, how to store them and where to store them ? In Decimal field ?

You can store and retrieve milliseconds using API, but the most of
API wrappers cut them off because they are using 'struct tm' for
conversions. You have to use UDF (Helen can tell you the name) to get
current time with milliseconds on server side.

SY, Dimitry Sibiryakov.