Postgres Pro
Downloads
Home   >   mailing lists

Re: Interval output format - Mailing list pgsql-novice

From Tom Lane
Subject Re: Interval output format
Date
Msg-id 4232.979843048@sss.pgh.pa.us
Whole thread Raw
In response to Interval output format  ("Stefan Waidele jun." <St.Waidele.jun@Krone-Neuenburg.de>)
Responses Re: Interval output format
List pgsql-novice
Tree view 
"Stefan Waidele jun." <St.Waidele.jun@Krone-Neuenburg.de> writes:
> How can I tell Postgres to return an interval value in an format like hhh:mm?

See to_char(),
http://www.postgresql.org/devel-corner/docs/postgres/functions-formatting.htm

            regards, tom lane

pgsql-novice by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Postgres superuser & password on Red Hat; upgrade?
Next
From: Tom Lane
Date:
Subject: Re: Yikes! Bitten by line length?