首页 > 代码库 > TIME_FORMAT(time, format)

TIME_FORMAT(time, format)

TIME_FORMAT(time, format) 用于格式化时间,即根据 format 指定的格式显示 time 值,format 格式

mysql> SELECT TIME_FORMAT(16:00:00, %H %k %I);+-------------------------------------+| TIME_FORMAT(16:00:00, %H %k %I) |+-------------------------------------+| 16 16 04                            |+-------------------------------------+

 

 

 

   

TIME_FORMAT(time, format)