# 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

```sql
SELECT FROM_DAYS(736411);

```

```output

+-------------------+
| FROM_DAYS(736411) |
+-------------------+
| 2016-03-23        |
+-------------------+

```

***

Modified at: May 31, 2023

Source: [/db/v9.1/reference/sql-reference/date-and-time-functions/from-days/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/from-days/)

(An index of the documentation is available at /llms.txt)