# TO\_DAYS

Returns the day number of the input date object.

Day number starts with 1 being 0000-01-01 and counts sequentially.

## Syntax

```
TO_DAYS ( dateobj )

```

## Arguments

* dateobj: a valid date, datetime, or parsable date string.

## Return Type

Integer

## Examples

```sql
SELECT TO_DAYS('1901-01-01');

```

```output

+-----------------------+
| TO_DAYS('1901-01-01') |
+-----------------------+
|                694326 |
+-----------------------+

```

```sql
SELECT TO_DAYS('2016-03-23 08:17:01');

```

```output

+--------------------------------+
| TO_DAYS('2016-03-23 08:17:01') |
+--------------------------------+
|                         736411 |
+--------------------------------+
```

***

Modified at: April 21, 2025

Source: [/cloud/reference/sql-reference/date-and-time-functions/to-days/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/to-days/)

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