# TIME\_FORMAT

Convert the input time object to a string according to the specified format.

```
TIME_FORMAT (timeobj, format)

```

## Arguments

* timeobj: a valid time, date, datetime, or parsable date string
* format: a string containing format symbols. Only format symbols for the hour, minute, second, and microsecond parts are valid.

See [DATE\_FORMAT](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/date-format.md) for a description of format symbols.

## Return Type

String

## Examples

```sql
SELECT TIME_FORMAT('12:05:47', '%s, %i, %h');

```

```output

+---------------------------------------+
| TIME_FORMAT('12:05:47', '%s, %i, %h') |
+---------------------------------------+
| 47, 05, 12                            |
+---------------------------------------+

```

***

Modified at: May 31, 2023

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

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