A minor nuisance is to determine the closing border of an arbitrary interval covering a date-time-value.
It would be nice to have CEIL(SYSDATE, 'MM'), CEIL(SYSDATE, 'YYYY'), etc. analogous to TRUNC(SYSDATE, 'MM'), TRUNC(SYSDATE, 'YYYY'), etc. It´s possible for instance, to use the calendaring syntax for this purpose, but it would be neater for configuration-entries, for selection of date-intervals, etc. to be able to use an equivalent of TRUNC.
(This is the renewal of the enhancement request 6331253.992, accepted — "Please monitor it from time to time keeping in mind that it may take some long time to be applied." — from Oracle on 31-May-2007.)