MySQL - Mostrar solo hora en que se capturo el registro

SELECT DATE_FORMAT(NOW(),"%H")

mysql_select_db($database_conexionBoletines, $conexionBoletines);

$query_Recordset1 = "SELECT notas.idContador, notas.strEncabezado,TIME_FORMAT(notas.strFecha,'%r')  FROM notas ORDER BY notas.idContador DESC";

$Recordset1 = mysql_query($query_Recordset1, $conexionBoletines) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

?>

<img src="images/minuto.jpg" width="353" height="40" />

<table width="353" border="1">

  <tr>

    <td width="38" height="31"><?php echo $row_Recordset1['TIME_FORMAT(notas.strFecha']; ?></td>

    <td width="299" height="31"></td>

  </tr>

</table>

SELECT notas.idContador, notas.strEncabezado,DATE_FORMAT(notas.strFecha,'%H') as Hora FROM notas ORDER BY notas.idContador DESC