| From: | Tomasz Myrta <jasiek(at)klaster(dot)net> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Does anyone use TO_CHAR(INTERVAL)? |
| Date: | 2003-03-25 19:24:55 |
| Message-ID: | 3E80AD07.5000005@klaster.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Uz.ytkownik Josh Berkus napisa?:
> Folks,
>
> We're discussing the behavior of the current "to_char(interval)" function on
> HACKERS. Does anyone on this list use the current behavior? Please speak
> up, as we're trying to figure out what backward compatibility needs to be
> maintained.
>
> PLEASE NOTE: This is only to_char() for INTERVAL values, NOT for dates,
> timestamp, or numeric!
In my projects intervals are always related to some dates when
displaying them, so I use to_char(date+interval).
It looks it could be useful to display how much time is left for
scheduling cases, but as I wrote few threads ago - displaying intervals
longer than one month is useless without specific date.
Anyway, maybe it should be left for future use, but without patterns
related to date, or maybe with DDD only?
Regards,
Tomasz Myrta
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roy Souther | 2003-03-25 20:01:17 | Insert race hazard condition. |
| Previous Message | Josh Berkus | 2003-03-25 17:31:27 | Does anyone use TO_CHAR(INTERVAL)? |