How do I filter a time coming through a select

Question

 $query = "SELECT horario FROM tempo WHERE teste = $teste";

Way it returns: 2019-07-26 19:24:17

Way I want it to return:19:24:17

Answer 1

You can use the function DATE_FORMAT to display the data you want to date in any way you want:

SELECT DATE_FORMAT(colName,'%H:%i:%s') AS horario
  FROM tempo

DATE_FORMAT

Formats the date value According to the format string.

In free translation:

Format date value according to format string.

Answer 2

You can also use as follows

SELECT TO_DATE(horario,'HH24:MI:SS') FROM tempo WHERE teste = $teste;

Answer 3

Postgresql SELECT EXTRACT(HOUR FROM TIMESTAMP '2001-02-16 10:30:15'); //10 SELECT EXTRACT(MINUTE FROM TIMESTAMP '2001-02-16 10:30:15'); //30 SELECT EXTRACT(SECOND FROM TIMESTAMP '2001-02-16 10:30:15'); //15

Mysql SELECT TIME('2019-07-07 11:28:46'); //11:28:46