# SEC\_TO\_TIME

Return a time object corresponding to the input second count.

## Syntax

```
SEC_TO_TIME ( sec )

```

## Arguments

* sec: an integer counting the seconds since midnight.

## Return Type

A time object.

## Examples

```sql
SELECT SEC_TO_TIME(84690);

```

```output

+--------------------+
| SEC_TO_TIME(84690) |
+--------------------+
| 23:31:30           |
+--------------------+

```

```sql
SELECT SEC_TO_TIME(-10000000);

```

```output

+------------------------+
| SEC_TO_TIME(-10000000) |
+------------------------+
| -838:59:59             |
+------------------------+
```

***

Modified at: May 31, 2023

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

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