Syntax
FROM_DAYS(N)
Purpose
You can call this function to return the DATE value that corresponds to the number of days specified for N. The number of days refers to the number of days from 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 (0.00 sec)