FROM_
On this page
Returns the date object corresponding to the input day number.
Day number starts with 1 being 0000-01-01 and counts sequentially.
Syntax
FROM_DAYS ( epoch )Arguments
-
epoch: day number, an integer.
Return Type
A date object.
Examples
SELECT FROM_DAYS(736411);
+-------------------+
| FROM_DAYS(736411) |
+-------------------+
| 2016-03-23 |
+-------------------+Last modified: May 31, 2023