Time Results Conversion - Mailing list pgsql-sql

From Brian C. Doyle
Subject Time Results Conversion
Date
Msg-id 4.3.2.7.2.20000827080015.00b54540@pop
Whole thread Raw
List 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?



pgsql-sql by date:

Previous
From: Rini Dutta
Date:
Subject: queries and inserts
Next
From: "Paulo Roberto Siqueira"
Date:
Subject: Select subset of rows