diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-05-07 04:24:34 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-05-07 04:24:34 +0000 |
| commit | 5894e7e36e3af7111fb420434ba0f262dcd3f6af (patch) | |
| tree | 1c4076530e6ee610f2be04a0e257f2d4e8a8bd83 /src/backend/utils/adt/oracle_compat.c | |
| parent | b63990c6a8387c8cae9c253508c333e267f9d442 (diff) | |
| download | postgresql-5894e7e36e3af7111fb420434ba0f262dcd3f6af.tar.gz postgresql-5894e7e36e3af7111fb420434ba0f262dcd3f6af.zip | |
Add items:
> * Prevent to_char() on interval from returning meaningless values
>
> For example, to_char('1 month', 'mon') is meaningless. Basically,
> most date-related parameters to to_char() are meaningless for
> intervals because interval is not anchored to a date.
>
> * Allow to_char() on interval values to accumulate the highest unit
> requested
>
> o to_char(INTERVAL '1 hour 5 minutes', 'MI') => 65
> o to_char(INTERVAL '43 hours 20 minutes', 'MI' ) => 2600
> o to_char(INTERVAL '43 hours 20 minutes', 'WK:DD:HR:MI') => 0:1:19:20
> o to_char(INTERVAL '3 years 5 months','MM') => 41
>
> Some special format flag would be required to request such
> accumulation. Such functionality could also be added to EXTRACT.
> Prevent accumulation that crosses the month/day boundary because of
> the uneven number of days in a month.
>
Diffstat (limited to 'src/backend/utils/adt/oracle_compat.c')
0 files changed, 0 insertions, 0 deletions