TIME_FORMAT
Syntax
TIME_FORMAT(time,format)
Description
This is used like the DATE_FORMAT() function, but the format string may contain format specifiers only for hours, minutes, and seconds. Other specifiers produce a NULL value or 0.
Examples
SELECT TIME_FORMAT('100:00:00', '%H %k %h %I %l'); +--------------------------------------------+ | TIME_FORMAT('100:00:00', '%H %k %h %I %l') | +--------------------------------------------+ | 100 100 04 04 4 | +--------------------------------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.