Subject Re: [IBO] TIMESTAMP question
Author Helen Borrie
At 08:39 AM 10/12/2004 +0200, you wrote:

>As far as I know, a Firebird TIMESTAMP field is a 64bit field, am I correct?

No. Actually, it is two 32-bit signed integers, although you never have
need to know that, or understand how the engine resolves these numbers
internally. Unlike with Paradox, you can't take a number and resolve it to
a timestamp.

>Does anyone know whether this includes the milliseconds such as Delphi's
>TDateTime type variables?

A timestamp's subsecond part is ten-thousandths of a second. You need to
be aware that the server time, e.g. CURRENT_TIMESTAMP, 'NOW', etc., is
always stored with zero in the subseconds part. You can access the exact
timestamp only by using the external function GetExactTimestamp(), which
takes no argument. You will find it in fbudf.