Re: Interval Precision

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

In response to

Responses

Browse pgsql-novice by date

  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