TO_DAYS
Returns the day number of the input date object.
Day number starts with 1 being 0000-01-01 and counts sequentially.
Syntax
TO_DAYS ( dateobj )
Arguments
dateobj: a valid date, datetime, or parsable date string.
Return Type
Integer
Examples
SELECT TO_DAYS('0000-01-01');
+-----------------------+
| TO_DAYS('0000-01-01') |
+-----------------------+
| 1 |
+-----------------------+SELECT TO_DAYS('2016-03-23 08:17:01');+--------------------------------+
| TO_DAYS('2016-03-23 08:17:01') |
+--------------------------------+
| 736411 |
+--------------------------------+