Product Solutions Support
Try MemSQL

TIME_FORMAT

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

TIME_FORMAT (timeobj, format)

Arguments

See DATE_FORMAT for a description of format symbols.

Return Type

String

Examples

memsql> select time_format('12:05:47', '%s, %i, %h');
+---------------------------------------+
| time_format('12:05:47', '%s, %i, %h') |
+---------------------------------------+
| 47, 05, 12                            |
+---------------------------------------+
Was this article useful?