TO_DAYS

The TO_DAYS() function 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('1901-01-01');
+-----------------------+
| TO_DAYS('1901-01-01') |
+-----------------------+
|                694326 |
+-----------------------+
SELECT TO_DAYS('2016-03-23 08:17:01');
+--------------------------------+
| TO_DAYS('2016-03-23 08:17:01') |
+--------------------------------+
|                         736411 |
+--------------------------------+

Last modified:

Was this article helpful?