Time Results Conversion

From: "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Time Results Conversion
Date: 2000-08-27 12:05:31
Message-ID: 4.3.2.7.2.20000827080015.00b54540@pop
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-sql

Hello all,

I have now upgraded to 7.0.2 and am very pleased with it. I do have a
question about a result that I am getting. When I sum an interval field
will get "1 01:01:01" representing "25 hours 1 minute 1 second" The result
that I need is just the sum of the hours minutes and seconds and No
days!!!! ie roll the day back into the hour field. Is it possible for me
to do this and if so How?

Browse pgsql-sql by date

  From Date Subject
Next Message Paulo Roberto Siqueira 2000-08-27 19:50:04 Select subset of rows
Previous Message pierre 2000-08-26 22:15:23 shared memory leak in 7.0.2?