MySQL to_days ()

MySQL to_days (date) function to_days ( date)

Given a date , returns a number of days, starting from year 0.

Mysql> SELECT to_days (950501);

728779

Mysql> SELECT to_days (' 1997-10-07′);

729669

To_days () is not used for values before the Gregorian calendar (1582), because the lost date is not taken into account when the calendars are changed.

Keep in mind that the rules in MySQL date and time type convert the two-digit year value in a date to four-bit. For example, ' 1997-10-07′ and ' 97-10-07′ are considered the same date:

Mysql> SELECT to_days (' 1997-10-07′), To_days (' 97-10-07′);

--729669, 729669

The result of this function is unreliable for dates prior to 1582 (perhaps in other regions for the next year).

MySQL to_days ()