MySQL TO_DAYS() function

TO_DAYS() function

MySQL TO_DAYS() returns a number of days between a given date and year 0.

This function is useful in -

• TO_DAYS() can be used to calculate ages or durations in days, which can be useful for tasks like determining the age of a person based on their birthdate.
• It's valuable for sorting records or data based on dates in ascending or descending order of days since year 0.
• It's used in time series analysis to perform calculations based on the numeric representation of dates.
• TO_DAYS() enables you to calculate date ranges based on the numeric representation of dates.
• TO_DAYS() supports the analysis of historical data by providing a consistent numeric representation of dates.
• The function is useful for filtering records or data based on date criteria, such as selecting records within a specific date range.

Syntax:

TO_DAYS(date);

Where date is a date.

Syntax Diagram:

MySQL Version: 8.0

Pictorial Presentation:

Example:

The following statement will return the number of days from year 0 to 2009-05-18.

Code:

SELECT  TO_DAYS('2009-05-18');

Output:

mysql> SELECT  TO_DAYS('2009-05-18');
+-----------------------+
| TO_DAYS('2009-05-18') |
+-----------------------+
|                733910 | 
+-----------------------+
1 row in set (0.03 sec)

Example: TO_DAYS() function using numeric format

The following statement will return the number of days from year 0 to 20090518.

Code:

SELECT  TO_DAYS(20090518);

Output:

mysql> SELECT  TO_DAYS(20090518);
+-------------------+
| TO_DAYS(20090518) |
+-------------------+
|            733910 | 
+-------------------+
1 row in set (0.00 sec)

Video Presentation:

All Date and Time Functions:

Click here to see the MySQL Date and time functions.

Previous: TIMESTAMPDIFF()
Next: UNIX_TIMESTAMP()