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 <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
