Subject RE: [ib-support] 'Time manipulation' or 'The Vulcan Science Directorate says it impossible'
Author Leyne, Sean
> Hello All,
> I need to store time durations in Firebird. For
> example, the length of a production cycle. lets say,
> (2 minutes, 32 seconds). If I use the Time data type
> and input '0:02:32' it interprets it as a time value
> of '12:02:32 AM'. What is the best method for storing
> time durations. All help is greatly appreciated.
> The Ever Needy,
> Derek Basch

In our application we store durations as integer values of seconds,
therefore 2:32 -> 152.