Re: Interval Precision
От | Jake Stride |
---|---|
Тема | Re: Interval Precision |
Дата | |
Msg-id | 4256D8D9.80305@users.sourceforge.net обсуждение исходный текст |
Ответ на | Re: Interval Precision (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: Interval Precision
Re: Interval Precision |
Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: