Re: Timestamp/Interval proposals: Part 2 - Mailing list pgsql-hackers

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  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz