FROM_DAYS(N): Given a day number N, returns a DATE value : FROM_DAYS « Date Time Functions « MySQL Tutorial






mysql>
mysql> SELECT FROM_DAYS(729669);
+-------------------+
| FROM_DAYS(729669) |
+-------------------+
| 1997-10-07        |
+-------------------+
1 row in set (0.00 sec)

mysql>








14.18.FROM_DAYS
14.18.1.FROM_DAYS(N): Given a day number N, returns a DATE value