Subject Working with TIME in SQL Interbase
Author Tony
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.