bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL TO_DAYS() Function

Example

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.

Note

This function is the opposite of the FROM_DAYS() function.

Syntax

TO_DAYS(
date
)

Parameter Values

ParameterDescription
dateRequired. The given date

Technical Details

Works in:From MySQL 4.0

Previous

MySQL TIMESTAMP() Function

Next

MySQL WEEK() Function