On 7 Jul 2003 at 16:17, Don Gollahon wrote:

> query.parambyname('call_time').astime := vtime;
>
>As I step thru the code, I see that vtime has the fractions of a day
>but query.parambyname('call_time').astime has lost the fraction after
>the assignment. Same happens if I use asdatetime. This works in our
>old tables when the call_date and call_time were together in a single
>timestamp field.

I'd say you use wrong component set. At least IBX and FIB+ (AFAIK)
use isc_encode/decode_time for converting from Delphi TDateTime
into/from IB native time format. Write to the autors and complain.
UIB handled time correctly.
If you don't want to change the component set you can use an
generated query with string literals.

SY, Dimitry Sibiryakov.