TIME_FORMAT
Sintassi
TIME_FORMAT(orario, formato)
Spiegazione
Questa funzione si usa come DATE_FORMAT(), ma la stringa formato specificatori di formato solo per le ore, minuti e secondi. Gli altri specificatori producono un risultato NULL o 0.
Esempi
MariaDB [(none)]> 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 |
+--------------------------------------------+
1 row in set (0.00 sec)
MariaDB [(none)]>
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.
