----- Original Message -----
From: "Tony " <apatri@...>
To: <IBObjects@egroups.com>
Sent: Monday, January 22, 2001 7:52 AM
Subject: [IBO] Working with TIME in SQL Interbase


> Good morning H.l. List.
>
> Someone want help me to translate this under INTERBASE NATIVE SQL???
>
> // sum worked hours
> if ( AField.FieldName = WORKEDHOURS' ) then begin
> AField.AsDateTime :=
> ARow.ByName('INITHOUR').AsDateTime - ARow.ByName
> (`FINISHHOUR').AsDateTime ;
> // if midnight 00.00
> if ( ARow.ByName('FINISHHOUR').AsString = '0.00.00' ) then
> AField.AsDateTime := StrToDateTime( '30/12/99 0.00.00' ) -
> AField.AsDateTime ;
>
> PS. Exist an INTERBASE NATIVE SQL discussion list??
>
> TIA
> Tony.
>
>
>
>
>