Hour from time field in mysql

[eluser]neosable[/eluser]
Hi,

I wonder how do I print the Hour segment from a time field using CI from mysql table

mysql_to_unix doesnt seem to work with time fields only with date ones.

thanks

[eluser]Randy Casburn[/eluser]
SELECT HOUR('10:05:03');