Hi everybody,

I need to save to the Firebird DB a time with millisecond precision.
I read an an article on the IBPhoenix site which describe how data must be encoded (iscTime +=(seconds_fraction % 10000)) , but I found no examples how to save millisconds. I mean:

PISC_TIME(sqldata) := PISC_TIME(sqldata) + (PISC_TIME(sqldata) % 10000 * msec)
or
PISC_TIME(sqldata) := PISC_TIME(sqldata) + msec
or
PISC_TIME(sqldata) := PISC_TIME(sqldata) + (msec % 10000)

isc_encode_sql_time(@TmpDate, PISC_TIME(sqldata))

msec info is not stored. So can someone provide an example how can I do to store msec infos?

Thank you
Lucio