On 22 Jan 2003 at 13:53, Michael.Straub@... wrote:

>fields. The IB documentation (Langref.pdf) states that ISC_TIME,
>ISC_DATE, and ISC_TIMESTAMP are all 64 bits. However ibase.h shows
>ISC_TIMESTAMP to be a structure containind ISC_TIME and ISC_DATE. From
>my testing I am showing the ISC_TIME and ISC_DATE to be 32 bits. Is
>the given size for ISC_TIME and ISC_DATE a typo?

Yes, Langref is wrong.

>The ISC_TIME appears to be a value based on the number of tenths of
>milliseconds from midnite. I adding a second to the struct tm and
>doing an isc_encode_timestamp() call bumped the ISC_TIME value by
>10,000 incrementing the minute added 600,000 to the value and
>incrementing the hour added 36,000,000 to the value. Is my
>interpretation of the format correct?

Yes, it is.

>I am trying to add milliseconds onto the timestamp value, but struct
>tm only goes to seconds. Can I use the struct tm in the
>isc_encode_timestamp() and then add the (milliseconds * 10) to the
>ISC_TIME portion of the timestamp to load into the sqlvars? To reverse
>the procedure would I isc_decode_timestamp() and then do a (ISC_TIME %
>10000)/10 to get out the milliseconds?

In my access components I don't use isc_(en/de)code_timestamp() at all
but encode and decode time by hands, because Delphi's format of date/time
is binary too. Direct conversion is faster.

> This seems to work but I want
>to make sure my assumptions are valid and this will continue to be
>supported in future versions.

I don't think that internal formats of date and time will be
changed in the foreseeable future. They are compact and wide enough.

SY, Dimitry Sibiryakov.