On Fri, Jun 07, 2002 at 06:48:31PM -0700, Thomas Lockhart wrote:
>
> > Proposal #4: Create to_char(INTERVAL, 'format string') Function.
> > Reason: self-evident, I think.
>
> Oh. Didn't know it wasn't already there.
I'm _sure_ that to_char() is there for interval.
testt=# select to_char('33s 15h 10m 5month'::interval, 'HH:MI:SS Month');
to_char
--------------------
03:10:33 May
(1 row)
test=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.95.4
(1 row)
And it's in the docs too....
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
