Syntax
FROM_DAYS(N)
Purpose
Returns the DATE value corresponding to the specified number of days N. The number of days is the number of days since 0000-01-01.
Examples
obclient> SELECT FROM_DAYS(736271), FROM_DAYS(700000);
+-------------------+-------------------+
| FROM_DAYS(736271) | FROM_DAYS(700000) |
+-------------------+-------------------+
| 2015-11-04 | 1916-07-15 |
+-------------------+-------------------+
1 row in set