Helen Borrie <helebor@...> writes:

> [...] Unless I've misunderstood the original question, this thread

relates not to

> getting greater precision from the system time, but to storing

date/time

> literals that include the subseconds portion...

> ./hb

This is correct. Helen, I understood your earlier post about
formatting a CAST; in fact, when the Firebird Book arrived that's the
first thing I looked up (a week or so ago, before this thread). Based
on the examples starting on page 149, in short order I was inserting
and selecting TIMESTAMP values with and without the fractional seconds.

The reason for this thread is that I was wondering if there was a way
to use the native Firebird timestamp data type, and some API other
than CAST, to store and retrieve the fractional seconds. IBPP doesn't
allow me to "Set()" a timestamp column using a string variable in a
prepared statement, even though the exact statement works correctly in
ISQL or FlameRobin; it's a data type conflict. Otherwise IBPP has
done what I've needed quite well.

So, until I get a better idea, I'll just define that column as a
character value. I can still do sorting and comparisons and that
meets my modest needs at this point.

Best regards, and thanks again,
Dave