| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>, Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, <pgsql-sql(at)postgresql(dot)org>, <jasiek(at)klaster(dot)net> |
| Subject: | Re: Formatting intervals.. |
| Date: | 2003-03-21 10:05:32 |
| Message-ID: | Pine.LNX.4.44.0303201925510.2112-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Karel Zak writes:
> test=# select to_char('3month 15d 4h 10m'::interval, 'DD-Mon HH24:MI:SS');
> to_char
> -----------------
> 15-Mar 04:10:00
This doesn't seem correct. First, you can't make "March" out of "3
months". Second, 3 months, 15 days and some hours after the start of the
year (if that definition were valid, which it isn't) is on March 16.
Third, why do you have to write "HH24"? Surely no one would want to write
out intervals using a 12-hour clock?
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karel Zak | 2003-03-21 10:30:11 | Re: Formatting intervals.. |
| Previous Message | Abdul Wahab Dahalan | 2003-03-21 08:28:26 | Cant get all records from dbase |