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)
Parameter Values
| Parameter | Description |
|---|---|
| date | Required. The given date |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the number of days between the date and year 0:
SELECT TO_DAYS("2017-06-20 09:34:00");