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.