| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| 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-10 09:13:29 |
| Message-ID: | 1023700409.4416.10.camel@taru.tm.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 2002-06-10 at 09:58, Karel Zak wrote:
> 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)
Does "May" make sense for an _interval _ ? (Feb 22 + May = Jul 22)?
Would not "5 months" make more sense ?
Or is it some ISO standard ?
Ditto for 15h -> 03 .
--------------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Griffiths(RA) | 2002-06-10 13:27:24 | Re: Missing types in C header files |
| Previous Message | Karel Zak | 2002-06-10 08:49:30 | Re: Timestamp/Interval proposals: Part 2 |