Outdated Version

You are viewing an older version of this section. View current production version.

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