extracting hour value from a DATETIME format

Question

How would I get the hours from a DATETIME format variable.

Example: 2009-08-17 13:00:00

And I just need to get '13'

Answer 1

You can use the HOUR() function:

mysql> SELECT HOUR('2009-08-17 13:00:00');
+-----------------------------+
| hour('2009-08-17 13:00:00') |
+-----------------------------+
|                          13 |
+-----------------------------+

Answer 2

in php,

list($date, $time) = explode(' ', '2009-08-17 13:00:00');
list($hour, $min, $sec) = explode(':', $time);

$hour should contain 13.

Answer 3

$hour = date("H", strtotime('2009-08-17 13:00:00'));