Subject | Is it possible to insert an INTEGER into a TIME field? |
---|---|
Author | jeff_j_dunlap |
Post date | 2007-09-15T07:08:39Z |
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
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