At 02:30 AM 8/02/2005 +0000, you wrote:

>Fractional seconds in timestamps can be achieved like this
>Tested with FB1.5.2 and Delphi 7
>
>1. use ibexpert or similar to register the UDF GETEXACTTIMESTAMP
> here is how the metadata should look like afterwards

Correct; but GetExactTimeStamp() is a no-input function call that returns
the system date and time with exact subseconds. It's exists because the
date literal 'now', and the context variables CURRENT_TIME and
CURRENT_TIMESTAMP return fractional seconds as .0000.

Unless I've misunderstood the original question, this thread relates not to
getting greater precision from the system time, but to storing date/time
literals that include the subseconds portion...

./hb