>Hello, recently i created a query where i rest fields with the datetime function, so this is my query:
>
>SELECT call.number, call.ing,;
> call.closed - call.open AS tmptotaten;
> FROM helpdesk!call;
> WHERE NOT EMPTY(call.closed) = .T.;
> AND NOT EMPTY(call.open) = .T.
>
>well my question is simple when i substract call.closed - call.open it display big numbers as a result of the operation, for example:
>01/01/2001 11:20:31 AM - 03/01/2001 12:00:00 PM = 3821389
>this result: 3821389 are seconds, minutes or hours?
>
When you substruct two datetime values the result is in seconds.
--sb--