Skip to Main Content

"CEIL"-function for dates

Carsten KaftanJan 7 2015 — edited May 7 2020

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.)

Post Details
Added on Jan 7 2015