--- In firebird-support@yahoogroups.com, "Anderson Farias"
<peixedragao@...> wrote:

>
> Hi,
>
> Use TIME fields only when you what to store a 'point in time' (on a

day).

> OTOH, if you whant to store an "amount of time" use INTEGER (or

some

> numeric) to store it in some unit defined by you (eg: minutes).
>
> Later you can cast your TIME fields to timestamp and add your 'qty

of

> minutes' to it, ex:
>
> select cast(mytimefield as timestamp)+(myminutesfield/1440.000000)

from

> table
>
> (this is only an exemple, assuming myminutesfield is an integer

containing

> the amount of time in minutes)
>
> the amount of zeroes after 1440 is the precision you what for the

result

>
>
> Regards,
> Anderson

Thanks for the information.

Regards,

Jeff