How to extract only Hour data from PHP Time string?

I have a col开发者_高级运维lection of time records in a database in the format '09:51:06' (hour, minute, second).

I have a query which retrieves a bunch of these times from the database, but I only care for the Hour reference.

How can I get rid of the rest of the string and ad just the hour into an array? So in the example above, I just want to keep '09'.

I've looked into exploding and substrings, but can't seem to figure it out.

Thanks.

Exploding the string would look like this (you probably want to add intval() to be able to use it as a real number):

$hours = array_shift(explode(':', '09:51:06'));

But you are probably looking for the right query instead of doing this afterwards. If you are dealing with a time-type, you can use MySQL's date and time functions (HOUR() in this case):

SELECT HOUR(`time_column`) AS `hour` FROM `your_table`

Or from the database itself

SELECT TIME_FORMAT(field_name, '%H') as return_hour from table_name

$time_string='09:51:06';
$your_array[$array_index]=substr($time_string, 0, 2);

for more info on substr

I guess you can do this either thru string manipulation or time/date. Any worthwhile date way would be on the SQL side, PHP has mktime and date functions but you would have get the hour you're looking for intermediately along the way if you were to construct a date anyway

String

$thisHour = array_shift(explode(':', $timeString));  //this gets hour
$thisHour - substr($timeString, 0, 2);              // or this
$hours[] = $thisHour;                               //this adds to array