Postgres Pro
Downloads
Home   >   mailing lists

Re: fomatting an interval - Mailing list pgsql-general

From Tom Lane
Subject Re: fomatting an interval
Date
Msg-id 25315.1052788160@sss.pgh.pa.us
Whole thread Raw
In response to Re: fomatting an interval  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: fomatting an interval  (Joseph Shraibman <joseph@xtenit.com>)
Re: fomatting an interval  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
Tree view 
>>> How can I format an interval?

Well, there are several possibilities such as to_char() and EXTRACT()
...

> I want something like the default format but without the milliseconds.

... but for this particular problem, why not just round the given
interval to an integral number of seconds, by casting it to interval(0)?

            regards, tom lane

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: fomatting an interval
Next
From: Joseph Shraibman
Date:
Subject: Re: fomatting an interval (resend)