Declaration
FROM_DAYS(N)
Description
Returns the DATE value corresponding to the specified number of days N. The number of days refers to the number of days elapsed 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