Subject | Working with TIME in SQL Interbase |
---|---|
Author | Tony |
Post date | 2001-01-22T14:52:45Z |
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.
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.