From: | Jake Stride <nsuk(at)users(dot)sourceforge(dot)net> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Interval Precision |
Date: | 2005-04-08 19:17:45 |
Message-ID: | 4256D8D9.80305@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Bruno Wolff III wrote:
>On Fri, Apr 08, 2005 at 19:52:00 +0100,
> Jake Stride <nsuk(at)users(dot)sourceforge(dot)net> wrote:
>
>
>>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?
>>
>>
>
>You can use the to_char function to format the output.
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
That works, thanks but what about this from the manual:
' Warning: |to_char|(interval, text) is deprecated and should not be
used in newly-written code. It will be removed in the next version.'
Thanks
Jake
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2005-04-08 19:21:48 | Re: Interval Precision |
Previous Message | Jake Stride | 2005-04-08 18:52:00 | Interval Precision |