# TO\_SECONDS

Returns the number of seconds counting from year 0 to the input datetime.

## Syntax

```
TO_SECONDS ( dateobj )

```

## Arguments

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

## Return Type

Integer

## Examples

```sql
SELECT TO_SECONDS('0000-01-01');

```

```output

+--------------------------+
| TO_SECONDS('0000-01-01') |
+--------------------------+
|                    86400 |
+--------------------------+

```

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

```

```output

+-----------------------------------+
| TO_SECONDS('2016-03-23 08:17:01') |
+-----------------------------------+
|                       63625940221 |
+-----------------------------------+
```

***

Modified at: May 31, 2023

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

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