Re: fomatting an interval (resend)

From: jks(at)selectacast(dot)net
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: fomatting an interval (resend)
Date: 2003-05-13 17:41:42
Message-ID: Pine.LNX.4.44.0305131341190.7420-100000@p1.selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, 13 May 2003, Steve Crawford wrote:

> How about:
>
> select to_char(finish-start, 'HH24:MI:SS') from timetable;
> to_char
> ----------
> 00:01:29
>
> This won't work if the interval is > 24 hours - you would have to add
> formatting to allow for days.
>

... which is exactly my problem.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2003-05-13 17:52:47 Re: OpenVMS Port?
Previous Message Josh Berkus 2003-05-13 16:22:14 OpenVMS Port?

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2003-05-13 18:04:56 Re: Scheduled Jobs
Previous Message Tom Lane 2003-05-13 17:30:54 Re: GUC and postgresql.conf docs