MySQL HOUR() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MySQL HOUR() Function
❮ MySQL Functions
Example
Return the hour part of a datetime:
SELECT HOUR("2017-06-20 09:34:00");Try it Yourself »
Definition and Usage
The HOUR() function returns the hour part for a given date (from 0 to 838).
Syntax
HOUR(datetime)Parameter Values
| Parameter | Description |
|---|---|
| datetime | Required. The datetime value to extract the hour from |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the hour part of a datetime:
SELECT HOUR("838:59:59");Try it Yourself »
❮ MySQL Functions
