| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | Thomas Lockhart <lockhart(at)fourpalms(dot)org>, josh(at)agliodbs(dot)com, hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Timestamp/Interval proposals: Part 2 |
| Date: | 2002-06-11 07:34:36 |
| Message-ID: | 20020611093436.A19916@zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Jun 10, 2002 at 07:18:44PM +0200, Hannu Krosing wrote:
OK, I add to_interval() to may TODO (but it's unsure for 7.3).
> hannu=# select to_char('33s 15h 10m 5months'::interval, 'YYYY.MM.DD
> HH24:MI:SS');
> to_char
> ---------------------
> 0000.05.00 15:10:33
> (1 row)
I think, we can keep this behaviour for to_char(), the good thing
is that you can formatting interval to strings that seems like
standard time (15:10:33), etc.
The to_interval() will have another (you wanted) behaviour.
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 | Dann Corbit | 2002-06-11 07:59:24 | Re: PostGres Doubt |
| Previous Message | Curt Sampson | 2002-06-11 05:45:27 | Re: Will postgress handle too big tables? |