Three new SQL scalar functions for date and time calculations have been added to support time series and forecasting analysis. These new functions do not require a separate license.
DATECEILING Calculates a new date, time, or datetime value by increasing the provided value up to the nearest larger value of the specified multiple with the specified granularity.
DATEFLOOR Calculates a new date, time, or datetime value by reducing the provided value down to the nearest lower value of the specified multiple with the specified granularity.
DATEROUND Calculates a new date, time, or datetime value by rounding the provided value up or down to the nearest multiple of the specified value with the specified granularity.
For detailed information on each of the functions listed above, see “Alphabetical list of functions” in Chapter 4, “SQL Functions,” in Reference: Building Blocks, Tables, and Procedures.
