[Edit]

MySQL - difference between two time values

1 contributors

2 contributions

0 discussions

0 points

Created by:

Mohammad-Oneal

327

In this article, we would like to show you how to calculate the difference between two time values in MySQL.

Quick solution:

xxxxxxxxxx
 
-- SELECT TIMEDIFF('to_time','from_time');
SELECT TIMEDIFF('HH:MM:SS','HH:MM:SS');

Where:

HH - hour number (from 00 to 24),
MM - minute number (from 00 to 59),
SS - second number (from 00 to 59).

Practical example

Edit

In this example, we will calculate the difference between two time values using TIMEDIFF() function.

Query:

xxxxxxxxxx
 
SELECT TIMEDIFF('09:30:00','08:00:00') AS 'time difference';

Result:

Edit

Show discussions ...

Donate to Dirask

Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!

Direct link

Join to our subscribers to be up to date with content, news and offers.

MySQL - dates

MySQL - DATE, TIME, DATETIME, and TIMESTAMP differences

MySQL - DATEDIFF() function example

MySQL - DATE_FORMAT() function example

MySQL - HOUR() function example

MySQL - MINUTE() function example

MySQL - NOW() function example

MySQL - SECOND() function example

MySQL - TIMEDIFF() function example

MySQL - TIMESTEMP() function example

MySQL - WEEKDAY() and DAYOFWEEK() differences

MySQL - combine DATE and TIME column into TIMESTAMP

MySQL - combine DATE and TIME into TIMESTAMP

MySQL - compare datetime values

MySQL - convert date to month name

MySQL - convert date to weekday name

MySQL - convert date to weekday number

MySQL - count rows per day

MySQL - count rows per hour

MySQL - count rows per month

MySQL - count rows per year

MySQL - date to string (dd/mm/yyyy)

MySQL - difference between two dates

MySQL - difference between two datetimes

MySQL - difference between two time values

MySQL - extract HOUR from DATETIME / TIMESTAMP / TIME

MySQL - extract MINUTE from DATETIME / TIMESTAMP / TIME

MySQL - extract SECOND from DATETIME / TIMESTAMP / TIME

MySQL - get current date and time

MySQL - group datetime by time hour

MySQL - group rows by year

MySQL - select between two dates

MySQL - set current DATETIME as default

MySQL - strip time from datetime column

MySql - group rows by days

MySql - group rows by months

MySql - how to convert unix timestamp to datetime?

MySql - select rows with dates between

MySql - subtract days from current date

Native Advertising

🚀

Get your tech brand or product in front of software developers.

For more information Contact us

Dirask - we help you to

solve coding problems.

Ask question.

❤️💻 🙂

Join