I need to reformat Time values into other display format. Is there any way?
You can reformat time values into other display formats using the TIME_FORMAT() function in MySQL. Take examples:
TIME_FORMAT(time_expression, format_string)
SELECT TIME_FORMAT( CURRENT_TIME, '%f' );
SELECT TIME_FORMAT( '45:30:00', '%h:%i' ); #will show hour and minutes
SELECT TIME_FORMAT(CURRENT_TIME, '%h:%i' );