Subject | Re: [firebird-support] Re: Problem with TIMESTAMP field precision |
---|---|
Author | ibrahim bulut |
Post date | 2005-08-18T06:47:33Z |
i have a question
which unit of IBX you changed with this code
which unit of IBX you changed with this code
----- Original Message -----
From: "alexanderl3" <alexanderl@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, August 18, 2005 2:33 AM
Subject: [firebird-support] Re: Problem with TIMESTAMP field precision
> Thanks a lot. It works fine now.
>
>
> --- In firebird-support@yahoogroups.com, "Dmitry Sibiryakov"
> <SD@t...> wrote:
>> On 17 Aug 2005 at 1:01, alexanderl3 wrote:
>>
>> >Is it a bug or I need to change some settings to allow higher
>> >resolution? Is it in IBX5, API DLL or FB itself?
>>
>> This is a bug. From my POV it is in IB API (isc_encode_timestamp
> ())
>> and IBX (that use this function).
>>
>> >If it is IBX5 problem, what other controls can be used to work with
>> >miliseconds?
>>
>> Hands.drv and Brain.sys.
>>
>> 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.
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> __________ NOD32 1.1196 (20050817) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>