Subject | Re: [firebird-support] Problem with TIMESTAMP field precision |
---|---|
Author | Dmitry Sibiryakov |
Post date | 2005-08-17T05:44:56Z |
On 17 Aug 2005 at 1:01, alexanderl3 wrote:
and IBX (that use this function).
const
IBTimeDivider=24*60*60*10000;
IBDateOffset=-15018;
Field.AsDateTime := Date; // Initialize buffer
With PISC_TIMESTAMP(Field.Data^.sqldata)^ do
begin
timestamp_date := Trunc(Value)-IBDateOffset;
timestamp_time := Round(IBTimeDivider*Abs(Frac(Value)));
end;
--
SY, Dimitry Sibiryakov.
>Is it a bug or I need to change some settings to allow higherThis is a bug. From my POV it is in IB API (isc_encode_timestamp())
>resolution? Is it in IBX5, API DLL or FB itself?
and IBX (that use this function).
>If it is IBX5 problem, what other controls can be used to work withHands.drv and Brain.sys.
>miliseconds?
const
IBTimeDivider=24*60*60*10000;
IBDateOffset=-15018;
Field.AsDateTime := Date; // Initialize buffer
With PISC_TIMESTAMP(Field.Data^.sqldata)^ do
begin
timestamp_date := Trunc(Value)-IBDateOffset;
timestamp_time := Round(IBTimeDivider*Abs(Frac(Value)));
end;
--
SY, Dimitry Sibiryakov.