| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
| Cc: | josh(at)agliodbs(dot)com, hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Timestamp/Interval proposals: Part 2 |
| Date: | 2002-06-10 07:58:59 |
| Message-ID: | 20020610095859.B23410@zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2002-06-10 08:49:30 | Re: Timestamp/Interval proposals: Part 2 |
| Previous Message | Jean-Michel POURE | 2002-06-10 07:41:15 | Re: How can we help? |