Example
Return the number of days between the date and year 0:
SELECT TO_DAYS("2017-06-20");
Definition and Usage
The TO_DAYS() function returns the number of days between a date and year 0 (date “0000-00-00”).
The TO_DAYS() function can be used only with dates within the Gregorian calendar.
Syntax
TO_DAYS(date)