DAYS

The DAYS_BETWEEN function returns the number of days since January 1, 0001, including that beginning date.

Syntax

DAYS (date_expression)

Remarks

•

TDV natively implements the version of the DAYS function.

•

The Excel DAYS function is far different from the TDV/ DAYS function.

Examples

SELECT DAYS ('0001-01-02')

This example returns 2.

SELECT DAYS ('2001-01-02')

This example returns 730487.