Subject | Timestamp variable with fractional seconds |
---|---|
Author | dave@brooksnet.com |
Post date | 2005-02-07T19:36:42Z |
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
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