| 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: | Whole Thread | Raw Message | 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 |