On Mon, Aug 18, 2003 at 16:09:43 +0200,
Bjørn T Johansen <btj@havleik.no> wrote:
> I need to compute the difference of Time fields, in the format HHMM. Is
> it possible to do the math in the Select?
Despite what it says in the documentation, you can't use that format
for the type time.
If timestamps will work for you, you can use to_timestamp to convert
to a timestamps and then subtract them to get an interval.
Another option would be to massage the strings to use a : separator
between the hours and minutes fields and then cast the strings to times.