Subject Timestamp variable with fractional seconds
Author dave@brooksnet.com
Hello,

Public thanks to those who helped me with basic API pointers the other
day; I already sent private thanks.

Question: how to insert a date variable with fractional seconds? I
already checked the file ApiGuide.pdf in the Interbase 6.0 docs; the
routines isc_timestamp_encode & _decode use a struct tm which does not
include fractional seconds. The IBPP::Timestamp variable also does
not support this, according to the list experts.

I already figured out how to insert and select using CAST with a
character variable and a date variable; however, this causes an
exception if you insert using IBPP.

The Firebird book rocks! This is how I found out about the CAST.
But, to do this from my application, I'll have to use an immediate
rather than a compiled statement. So, I guess my question is:

How to do this in a compiled statement using a timestamp column, and
IBPP if possible (unless there is a class library that is more
favored; I like IBPP even with the gaps in documentation)?

Any assistance would be appreciated.

Best regards,
Dave