Converting dates in an array!

[bjblackmore]

Hi,
I am pulling information from a database, in an array, and 1 of the values is a time field (HH:MM:SS), how do I display this in just HH:MM format?
Many Thanks
Ben

[djg_uk]

Hi Ben;

It's a shame that the values aren't stored as a UNIX timestamp, as this would make things much easier.

Try splitting the H,M and S into an array by doing the following:

$time_array = split(":", $time);

where $time is the value from the database.

Then use:

$new_time = date("H:i", mktime($time_array[0],$time_array[1],$time_array[2]));

This will give $new_time the format of say: 20:07 for the time...

Cheers,

-D.

[bjblackmore]

Ok, solved I used...
$time = explode(":", $rs[31]); echo "$time[0]:$time[1]
Cheers
Ben

[bjblackmore]

Ah ok, I might try that, I've just used explode, which looks simular to what you had.
Cheers
Ben