Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
FROM_ DAYS
On this page
The FROM_ function 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: