Interval calculations

Variables containing dates will often be used to find the time for an event. To find the answer, interval calculations will come in handy. We will explore the INTNX and INTCK functions in the following section.

INTNX and INTCK

The most useful functions for calculating date values, datetime values, and time intervals are INTNX and INTCK. These functions help in interval calculations. In common coding parlance, you can refer to INTNX as an interval check and INTCK as an interval next function. What this means is that INTNX checks for intervals whereas INTCK is useful for computing a date/datetime value on the basis of a different date/datetime value. Apart from this difference, there is a minor difference...