Interval Precision

From: Jake Stride <nsuk(at)users(dot)sourceforge(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Interval Precision
Date: 2005-04-08 18:52:00
Message-ID: 4256D2D0.6020006@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm trying to force the precision on an interval so that I can store
hours and minutes and then when I do a select just see the hours and
minutes. i.e.:

01:00 instead of 01:00:00

is the possible as no matter what I set the precision to I always get
the extra seconds. Is this possible?

Thanks

Jake

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jake Stride 2005-04-08 19:17:45 Re: Interval Precision
Previous Message Bob Henkel 2005-04-08 17:11:25 Re: Getting running totals