I have a statement looking like this...: select sum(Til - Fra) as total from Log_stop where OrdreID = 3434
but I would like the result to be in milliseconds, is this possible? If so, how? (the fields Til and Fra is of type Time) Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bjørn T Johansen [EMAIL PROTECTED] ----------------------------------------------------------------------------------------------- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" ----------------------------------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
