SQL•SQL References

MySQL HOUR() Function

Example

SELECT HOUR("2017-06-20 09:34:00");

Definition and Usage

The HOUR() function returns the hour part for a given date (from 0 to 838).

Syntax

HOUR(
datetime
)

Parameter	Description
datetime	Required. The datetime value to extract the hour from

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT HOUR("2017-06-20 09:34:00");

The HOUR() function returns the hour part for a given date (from 0 to 838).

Syntax

HOUR(
datetime
)

Parameter	Description
datetime	Required. The datetime value to extract the hour from

Works in:	From MySQL 4.0