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)]> 

Commenti

Sto caricando i commenti......
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.