Syntax
------

FROM_DAYS(N)

Description
-----------

Given a day number N, returns a DATE value. The day count is based on the
number of days from the start of the standard calendar (0000-00-00).

The function is not designed for use with dates before the advent of the
Gregorian calendar in October 1582. Results will not be reliable since it
doesn't account for the lost days when the calendar changed from the Julian
calendar.

This is the converse of the TO_DAYS() function.

Examples
--------

SELECT FROM_DAYS(730669);
+-------------------+
| FROM_DAYS(730669) |
+-------------------+
| 2000-07-03        |
+-------------------+

URL: https://mariadb.com/kb/en/from_days/