MySQL TO_DAYS() Function

MySQL TO_DAYS() Function; Through this tutorial, i am going to show you MySQL TO_DAYS() function with the help of examples.

MySQL TO_DAYS function is the Date Function, which is used to return the total number of days from year 0 to user given date.

Syntax of MySQL TO_DAYS() Function

The basic syntax of MySQL to_days() is:

TO_DAYS(date)

Here is the date of use in date calculations.

Example 1 – MySQL TO_DAYS() Function

Take an first example using the to_day function; as follows:

SELECT TO_DAYS('2000-12-31');

Output-1

+-----------------------+
| TO_DAYS('2000-12-31') |
+-----------------------+
|                730850 |
+-----------------------+

Note: Note however that the MySQL documentation advises that this function is not for use with those values that were before the arrival of the Gregorian calendar (1582).

Example 2 – MySQL TO_DAYS() Function

Let’s take an second example using curdate() and to_days() of MySQL; as follows:

    SELECT 
    CURDATE(),
    TO_DAYS(CURDATE());

Output-2

+------------+--------------------+
| CURDATE()  | TO_DAYS(CURDATE()) |
+------------+--------------------+
| 2019-07-16 |             737621 |
+------------+--------------------+

First of all, we use the MySQL CURDATE () function to return the current date, after that, we pass that function to the TO_DAYS () function to return the number of days that day 0 is.

Example 3 – MySQL TO_DAYS() Function

Let’s take an third example using the msyql now() with to_days() function; as follows:

    SELECT 
    NOW(),
    TO_DAYS(NOW());

Output-3

+------------------------+--------------------+
| NOW()                  | TO_DAYS(CURDATE()) |
+------------------------+--------------------+
| 2019-07-16 18:10:45    |             737621 |
+------------+--------------------------------+

First of all, use the MySQL NOW() function to return the current date and time value, after that, we pass that function to the TO_DAYS () function to return the number of days that day 0 is.

Conclusion

MySQL TO_DAYS() Function , you have learned how to use MySQL TO_DAYS() function. You have also learned different FROM_DAYS () and TO_DAYS () function of MySQL.

MySQL TO_DAYS() Function