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

Last modified: May 31, 2023

Was this article helpful?