On Mon, Aug 28, 2006 at 10:48:47AM +0200, Bjørn T Johansen wrote: > 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)
You could use extract(epoch from <interval>) to get the number of seconds (with fractional part) in an interval, then multiply by 1000 to get milliseconds. Example: select extract(epoch from sum(Til - Fra)) * 1000.0 ... -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
