TIME Format, Help!

[Anon]

Hi, please try and help me with the following...

I have created a form, with entries for a flight's departure time and arrival time. When you press submit, it adds the time to mysql table in format hh:mm:ss. I then create a PHP script to view all the rows in that table:

    echo "<b>Departure Time GMT: </b>";
echo $row["deptime"];
echo "<br>\n";
echo "<b>Arrival Time GMT: </b>";
echo $row["arvtime"];
echo "<br>\n";

That gives me this:

    Departure Time GMT: 17:00:00
    Arrival Time GMT: 21:00:00

QUESTION:

how do I get the output in HH:MM format? (instead of HH:MM:SS format).

Thanks for all helpings,
Ben

[Anon]

MySQL has a format command that will let you format the output of date/time fields. I don't remember it off the top of my head, but it's in the manual and very easy to use, something like:

select format(date_field, "HH:MM") from table;