MySQL
keyboard_arrow_down 295 guides
chevron_leftDate and Time
Method ADDDATEMethod ADDTIMEMethod CONVERT_TZMethod CURDATEMethod CURRENT_DATEMethod CURRENT_TIMEMethod CURRENT_TIMESTAMPMethod CURTIMEMethod DATEMethod DATE_ADDMethod DATE_FORMATMethod DATE_SUBMethod DATEDIFFMethod DAYMethod DAYNAMEMethod DAYOFMONTHMethod DAYOFWEEKMethod DAYOFYEARMethod EXTRACTMethod FROM_DAYSMethod FROM_UNIXTIMEMethod GET_FORMATMethod HOURMethod LAST_DAYMethod LOCALTIMEMethod LOCALTIMESTAMPMethod MAKEDATEMethod MAKETIMEMethod MICROSECONDMethod MINUTEMethod MONTHMethod MONTHNAMEMethod NOWMethod PERIOD_ADDMethod PERIOD_DIFFMethod QUARTERMethod SEC_TO_TIMEMethod SECONDMethod STR_TO_DATEMethod SUBDATEMethod SUBTIMEMethod SYSDATEMethod TIMEMethod TIME_FORMATMethod TIME_TO_SECMethod TIMEDIFFMethod TIMESTAMPMethod TIMESTAMPADDMethod TIMESTAMPDIFFMethod TO_DAYSMethod TO_SECONDSMethod UNIX_TIMESTAMPMethod UTC_DATEMethod UTC_TIMEMethod UTC_TIMESTAMPMethod WEEKMethod WEEKDAYMethod WEEKOFYEARMethod YEARMethod YEARWEEK
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
MySQL | HOUR method
schedule Aug 12, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
MySQL's HOUR(~) method returns the hour portion of a given time or datetime.
Parameters
1. time | time/datetime
The time/datetime to retrieve the hour from.
Return value
The hour portion of the input time or datetime.
Examples
Consider the following table about check in and check out times of some employees:
id | name | check_in | check_out |
|---|---|---|---|
1 | alex | 2020-04-16 09:30:01 | 2020-04-16 17:45:31 |
2 | bob | 2020-04-16 07:00:05 | 2020-04-16 15:28:22 |
3 | cathy | 2020-04-16 11:50:01 | 2020-04-16 20:05:40 |
The above sample table can be created using the code here.
Basic usage
To return the hour that employees came into work:
SELECT name, HOUR(check_in)FROM employment;
+-------+----------------+| name | HOUR(check_in) |+-------+----------------+| alex | 9 || bob | 7 || cathy | 11 |+-------+----------------+
To check for employees who came in before 8am:
SELECT name, HOUR(check_in)FROM employmentWHERE HOUR(check_in) < 8;
+------+----------------+| name | HOUR(check_in) |+------+----------------+| bob | 7 |+------+----------------+
To return hour from a time:
SELECT HOUR('48:05:55');
+------------------+| HOUR('48:05:55') |+------------------+| 48 |+------------------+
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
Official MySQL Documentation
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_hour
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
