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