Home / Database Structure / Data Types / Question No: 111

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' );