Subject Is it possible to insert an INTEGER into a TIME field?
Author jeff_j_dunlap
I know that we can save time values to a time field as follows:
insert into test(T) values('10:15:00.0000')

But how (if possible) do I save the time's integer value? For example:
Note: 10:15 a.m. equals 369000000
insert into test(T) values('369000000')

In my application, I am working directly with Firebird's time fields
corresponding integer value. Since the time value is already in
integer form, I would be easy and eficient to just store the integer,
thus eliminating a conversion to FB followed a FB conversion back to
integer before saving to disk.

If this is not possible, I will just convert the integer into the
corresponding time string each time I need to save a time value.

Thank you