Omnidex SQL Function: $COMPARE_DATE

The $COMPARE_DATES function determines the interval between two dates and returns that value as a fractional floating point value. The interval will default to days unless overridden using the unit parameter.

$COMPARE_DATES ( <date_column1 | 'date_string1' > , < date_column2 | 'date_string2 > 
    [, [date_unit] 
    [, options]
    )

An expression resulting in a date-class or string-class datatype

An expression resulting in a date-class or string-class datatype

A string containing a unit abbreviation identifying the type of interval. The supported abbreviations are the same as those found in the EXTRACT function.

A string containing options for this functions. No options exist at this time.

The result of the $COMPARE_DATES function is an INTEGER datatype reflecting the number of units between the two dates.