Add generic date/time functions into pattern template #1
Description
As SQL-92 standard does not support date/time functions and those functions are essential for predictors, it is desirable to define three generic functions, which would have database specific implementations:
@timeBetween(Unit, Date1, Date2) - semantics like SAS INTCK
@timeAdd(Unit, Date, UnitsToAdd, Alignment) - semantics like SAS INTNX
Unit being from {Day, Week, Month, Quarter, Year}.