Re: Hour difference?

Is there a way to get an interval in a standard format?  It seems like it
keeps changing it's ouput style based on the time length.

Jon

On Mon, 18 Aug 2003, Bruno Wolff III wrote:

> On Mon, Aug 18, 2003 at 16:09:43 +0200,
>   Bj�rn T Johansen <btj@havleik.no> wrote:
> > I need to compute the difference of Time fields, in the format HHMM. Is
> > it possible to do the math in the Select?
>
> Despite what it says in the documentation, you can't use that format
> for the type time.
> If timestamps will work for you, you can use to_timestamp to convert
> to a timestamps and then subtract them to get an interval.
> Another option would be to massage the strings to use a : separator
> between the hours and minutes fields and then cast the strings to times.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>