| Subject | Re: [ib-support] Re: Follow Up : 'Time manipulation' or 'The Vulcan Science Directorate says |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-09-22T02:57:29Z |
At 01:38 AM 22-09-02 +0000, you wrote:
environment. It's quite usual to bring the raw value (e.g. seconds as an
integer) into your client and format it with a local procedure.
Depending on what you have actually stored in the database, if you are
using Dialect 3 you could get back an integer for Seconds like this:
select <other fields>,
(24 * 60 * 60 * (FinishTime - StartTime))/1 AS IntervalInSeconds,
...
heLen
>It will be display in a column of a grid in H:M:S format.I think Greg is referring to a Delphi or BCCPB application development
>I would appreciate some code as I dont quite understand what your
>suggesting below.
environment. It's quite usual to bring the raw value (e.g. seconds as an
integer) into your client and format it with a local procedure.
Depending on what you have actually stored in the database, if you are
using Dialect 3 you could get back an integer for Seconds like this:
select <other fields>,
(24 * 60 * 60 * (FinishTime - StartTime))/1 AS IntervalInSeconds,
...
heLen