Re: Hour difference?

fingerless=# select '7:43'::time AS start, '12:17'::time AS end,
(('12:17'::time) - ('7:43'::time))::interval AS difference;
  start   |   end    | difference
----------+----------+------------
 07:43:00 | 12:17:00 | 04:34
(1 row)


Hope that helps.. Just subsitute your column names for the times.

--Steve


Bjørn T Johansen wrote:

>I need to compute the difference of Time fields, in the format HHMM. Is
>it possible to do the math in the Select?
>
>
>Regards,
>
>BTJ
>
>
>