is there a format for time only in mysql

Question

is there a format for time only in mysql

Answer 1

SELECT TIME('2003-12-31 01:02:03');

Answer 2

Take a look at TIME: http://www.tizag.com/mysqlTutorial/mysql-time.php

Also, you may store it in int with wudth depending on required precission.