--- In IBObjects@yahoogroups.com, "Gordon Hamm" <GHamm@...> wrote:

>
> What SQL would you use to get secondsbetween for 2 times? Thanks for the aid.
>
>

select (EXTRACT( HOUR FROM TIMEFIELD ) * 3600 ) + (EXTRACT( MINUTE FROM TIMEFIELD ) * 60 ) + EXTRACT( SECOND FROM TIMEFIELD )
from THETABLE