SingleStore DB

FROM_DAYS

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        |
+-------------------+