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 | TIMEDIFF method
schedule Aug 11, 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 TIMEDIFF(~) method returns the time difference between two time or datetime values. (i.e. expr1 - expr2)
Parameters
1. expr1 | time/datetime
A time/datetime to be subtracted from.
2. expr2 | time/datetime
A time/datetime to subtract.
NOTE
The two arguments must be of the same type. Either both times or both datetimes.
Return value
The time difference between the input time or datetime values (expr1 - expr2).
Examples
Two datetimes
To return the time difference between two datetime values:
SELECT TIMEDIFF('2020-04-16 07:54:30.555555', '2020-04-14 07:54:30.000000');
+---------------------------------------------------------------------+| TIMEDIFF('2020-04-16 07:54:30.555555', '2020-04-14 07:54:30.000000') |+---------------------------------------------------------------------+| 48:00:00.555555 |+---------------------------------------------------------------------+
Two times
To return the time difference between two time values:
SELECT TIMEDIFF('7:54:30.555555', '23:45:50.000000');
+----------------------------------------------+| TIMEDIFF('7:54:30.555555','23:45:50.000000') |+----------------------------------------------+| -15:51:19.444445 |+----------------------------------------------+
Note that as the second argument is a larger time value than the first, the returned time difference is negative.
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_timediff
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
