Bruno Wolff III wrote:
>On Fri, Apr 08, 2005 at 19:52:00 +0100,
> Jake Stride <nsuk@users.sourceforge.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