Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group